Home » RDBMS Server » Server Utilities » how do I export an OPS$USER_ACCT as OWNER
how do I export an OPS$USER_ACCT as OWNER [message #206842] Fri, 01 December 2006 13:35 Go to next message
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?

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 Go to previous messageGo to next message
Messages: 21146
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 - 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 - Produc
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.
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 Go to previous message
Mahesh Rajendran
Messages: 10677
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.
Previous Topic: Load data from URL
Next Topic: Loading table with subtypes from multiple files
Goto Forum:

Current Time: Wed Aug 16 22:57:42 CDT 2017

Total time taken to generate the page: 0.11011 seconds