Error While Export [message #140727] |
Wed, 05 October 2005 07:22 |
d.dineshkumar
Messages: 211 Registered: April 2005 Location: Kolkatta
|
Senior Member |
|
|
Hi All,
While exporting a user we are facing the following error.Pls Help us to find the solution.
-----------------------
D:\oracle\ora92\bin>exp
Export: Release 9.2.0.1.0 - Production on Wed Oct 5 17:37:01 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Username: my_user@orcl1
Password:
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
Enter array fetch buffer size: 4096 >
Export file: EXPDAT.DMP > d:\my_user.dmp
(2)U(sers), or (3)T(ables): (2)U >
Export grants (yes/no): yes >
Export table data (yes/no): yes >
Compress extents (yes/no): yes >
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user MY_USER
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user MY_USER
About to export MY_USER'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
--------------------
With Regds
Dinesh
|
|
|
|
|
|
|