| Error while exporting database [message #110785] |
Thu, 10 March 2005 05:44  |
vinu_vkumar
Messages: 45
Registered: March 2005
|
Member |
|
|
Dear All,
I installed oracle version 9.2.0.1 and directly applied the 9.2.0.6 patch on it. While performing an export of the database i created in it, I am getting the following oracle error
Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user DEV
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user DEV
About to export DEV's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 19206 encountered
ORA-19206: Invalid value for query or REF CURSOR parameter
ORA-06512: at "SYS.DBMS_XMLGEN", line 83
ORA-06512: at "SYS.DBMS_METADATA", line 345
ORA-06512: at "SYS.DBMS_METADATA", line 410
ORA-06512: at "SYS.DBMS_METADATA", line 449
ORA-06512: at "SYS.DBMS_METADATA", line 1156
ORA-06512: at "SYS.DBMS_METADATA", line 1141
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
Dont know if this patch application is the problem.(DEV is the data base user name by the way).
Thanks in advance.
Vinu
|
|
|
|
|
|
| Re: Error while exporting database [message #110909 is a reply to message #110801] |
Fri, 11 March 2005 00:14  |
vinu_vkumar
Messages: 45
Registered: March 2005
|
Member |
|
|
Dear Mahesh,
Sorry for not informing that this was an oracle installation on windows 2003 server. Pls let me know if there is anything that i missed during installtion. This has stopped my daily backup activity as planned.
Regards,
Vinu.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
