OraFAQ Forum: Server Utilities » Exp Oracle9i user/schema (Error 19206 encountered)

Home » RDBMS Server » Server Utilities » Exp Oracle9i user/schema (Error 19206 encountered) (9i, windowxp)

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

Exp Oracle9i user/schema (Error 19206 encountered) [message #300885]

Mon, 18 February 2008 08:24

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