OraFAQ Forum: Server Utilities » how do I export an OPS$USER

Home » RDBMS Server » Server Utilities » how do I export an OPS$USER_ACCT as OWNER

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how do I export an OPS$USER_ACCT as OWNER [message #206842]

Fri, 01 December 2006 13:35

Henry_VA
Messages: 12
Registered: September 2006
Location: Northern VA

Junior Member

I received an error when attempt to export an OPS$account that contains the '$' in the middle of the account name. WHat I really want is to export the trigger text of all triggers under this account.

For example:

exp system/passwdxyz file=ops_file.dmp log=ops_file.log owner="ops$accnt1" rows=no triggers=yes buffer=64000

Can you help?

Henry

Report message to a moderator

Re: how do I export an OPS$USER_ACCT as OWNER [message #206852 is a reply to message #206842]

Fri, 01 December 2006 14:41

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Perhaps there's a problem with Oracle database version? Which one is it (such information usually helps)? Because, on my Oracle 10g it works as expected: without problems:

SYS> create user ops$accnt1 identified by a;

User created.

SQL> exit

OS>exp system/pw file=test.dmp owner=ops$accnt1 rows=n triggers=y

Export: Release 10.2.0.1.0 - Production on Pet Pro 1 21:36:00 2006

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Export done in EE8MSWIN1250 character set and AL16UTF16 NCHAR character set
Note: table data (rows) will not be exported

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user OPS$ACCNT1
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user OPS$ACCNT1
About to export OPS$ACCNT1's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export OPS$ACCNT1's tables via Conventional Path ...
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.

Report message to a moderator

Re: how do I export an OPS$USER_ACCT as OWNER [message #206855 is a reply to message #206852]

Fri, 01 December 2006 14:47

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

May be the OP is using *nix.
The default method will not work.
The dollar sign need to be 'escaped'

 owner=ops\$accnt1 rows=n triggers=y

As Littlefoot said,
posting OS/Oracle versions will help.

Report message to a moderator

Previous Topic:	Load data from URL
Next Topic:	Loading table with subtypes from multiple files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 00:16:03 CST 2024