Home » RDBMS Server » Server Utilities » Exp Oracle9i user/schema (Error 19206 encountered) (9i, windowxp)
icon9.gif  Exp Oracle9i user/schema (Error 19206 encountered) [message #300885] Mon, 18 February 2008 08:24 Go to next message
oraclewannabe
Messages: 26
Registered: January 2008
Junior Member
hi i need to exp a schema/user call 'xyz' from my original PC to a new laptop..

i have done 2 different step to try to export
1) as system
2) as user ( i have gaven user exp_full_database role)

they both generate the same error

i go to cmd and i type

1) exp system/xxxxxx file=xyz.exp owner=xyz
2) exp xyz/password file=xyz.exp

i see the following start running
About to export specified users...
exporting pre-schema procedure...
exporting foreign library..
exporting public...
exporting private...
exporting object type definetion...

about to export xyz's objects
.export database links
.export sequence numbers
.export cluster definetation

EXP-00056: Oracle error 19206 encountered
ORA-19206: invalid value for query or ref cursor parameter
ORA-06512: at SYS.DBMS_XMLGEN", line23
.......... at SYS.DBMS_METADATA, line410
etc etc etc repeated
EXP-00000: export terminated unsuccesfully

advices gurus ? Smile
Re: Exp Oracle9i user/schema (Error 19206 encountered) [message #300888 is a reply to message #300885] Mon, 18 February 2008 08:34 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
login as sys.
Run catmeta.sql
try again.
Re: Exp Oracle9i user/schema (Error 19206 encountered) [message #301268 is a reply to message #300888] Tue, 19 February 2008 22:29 Go to previous messageGo to next message
oraclewannabe
Messages: 26
Registered: January 2008
Junior Member
thanks so much
Re: Exp Oracle9i user/schema (Error 19206 encountered) [message #385487 is a reply to message #300888] Mon, 09 February 2009 22:18 Go to previous messageGo to next message
avoolapati
Messages: 1
Registered: February 2009
Location: Hyderabad
Junior Member
Please send me catmeta.sql you sent on 18th Feb 2008
Re: Exp Oracle9i user/schema (Error 19206 encountered) [message #385508 is a reply to message #301268] Mon, 09 February 2009 23:36 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is in your ORACLE_HOME/rdbms/admin directory.

Regards
Michel
Previous Topic: Recover/Restore using Remote_Server backup file
Next Topic: DB trigger (merged)
Goto Forum:
  


Current Time: Sat Dec 03 20:24:11 CST 2016

Total time taken to generate the page: 0.09437 seconds