Home » RDBMS Server » Backup & Recovery » Error While Export
Error While Export [message #140727] Wed, 05 October 2005 07:22 Go to next message
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
Re: Error While Export [message #140734 is a reply to message #140727] Wed, 05 October 2005 07:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
seems some objects related to XMLDB are invalidated.
login as sys , run catmeta.sql ( found in $ORACLE_HOME/rdbms/bin), try again.
Else
Raise a TAR.
Re: Error While Export [message #140862 is a reply to message #140734] Wed, 05 October 2005 23:41 Go to previous messageGo to next message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
Thanks,
How can i know that this catmeta.sql is already run , or if i run, will it cause any harm to the existing things.

Regds
Dinesh
Re: Error While Export [message #140945 is a reply to message #140862] Thu, 06 October 2005 06:52 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It should not.
But how can i guarantee anything about your system without knowing it?
It is beyond the scope of the forum.
We can only suggest.
Re: Error While Export [message #140979 is a reply to message #140945] Thu, 06 October 2005 08:16 Go to previous message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
Great,

Thanks...

REgds
Dinesh
Previous Topic: RMAN EXPIRED BACKUP
Next Topic: oracle 10g RMAN
Goto Forum:
  


Current Time: Thu Apr 18 09:36:51 CDT 2024