Home » RDBMS Server » Server Utilities » EXPORT ERROR
EXPORT ERROR [message #73393] Tue, 13 April 2004 12:28 Go to next message
Michael Khan
Messages: 2
Registered: December 2003
Junior Member
I am running oracle 9.2.0.3 on windows 2k server. I am exporting a user and is getting the following error message.

15:29:07.528 Program . exporting object type definitions for user CMM
15:29:07.538 Program About to export CMM's objects ...
15:29:07.558 Program . exporting database links
15:29:07.688 Program . exporting sequence numbers
15:29:10.081 Program . exporting cluster definitions
15:29:10.111 Program EXP-00056: ORACLE error 19206 encountered
15:29:10.121 Program ORA-19206: Invalid value for query or REF CURSOR parameter
15:29:10.131 Program ORA-06512: at "SYS.DBMS_XMLGEN", line 83
15:29:10.141 Program ORA-06512: at "SYS.DBMS_METADATA", line 345
15:29:10.151 Program ORA-06512: at "SYS.DBMS_METADATA", line 410
15:29:10.171 Program ORA-06512: at "SYS.DBMS_METADATA", line 449
15:29:10.181 Program ORA-06512: at "SYS.DBMS_METADATA", line 1156
15:29:10.191 Program ORA-06512: at "SYS.DBMS_METADATA", line 1141
15:29:10.201 Program ORA-06512: at line 1
15:29:10.211 Program EXP-00000: Export terminated unsuccessfully

 

Any help will be appreciated.

Thanks in advance.

Michael
Re: EXPORT ERROR [message #73394 is a reply to message #73393] Wed, 14 April 2004 00:40 Go to previous messageGo to next message
ora9iDBA
Messages: 31
Registered: March 2003
Member
Hi

run following script
@?/rdbms/admin/catmeta.sql by connecting as user sys and then take a export.
This will resolve issue.

Kishor
Re: EXPORT ERROR [message #73538 is a reply to message #73393] Tue, 18 May 2004 20:40 Go to previous messageGo to next message
Ngoc Long Nguyen
Messages: 1
Registered: May 2004
Junior Member
Run:

$ORACLE_HOME/rdbms/admin/catmeta.sql (under user SYS)

Good luck!
Re: EXPORT ERROR [message #73553 is a reply to message #73394] Thu, 20 May 2004 17:26 Go to previous messageGo to next message
Jacky Rateng
Messages: 1
Registered: May 2004
Junior Member
I had run the catmeta.sql ,but I don't use the command line export the user ,I may use dba tools to do above export. I get the following error message in the command line :

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user STIUSER5
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user STIUSER5
EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00024: Export views not installed, please notify your DBA
EXP-00000: Export terminated unsuccessfully
Re: EXPORT ERROR [message #73981 is a reply to message #73553] Sat, 14 August 2004 03:25 Go to previous messageGo to next message
Amir
Messages: 8
Registered: April 2002
Junior Member
Looks like the export views are not correctly installed. Try doing this ;

1]] Log in as sys user
2]] run the $ORACLE_HOME/rdbms/catexp.sql file. This will recreate all your exp related views.
3]] run the exp again.

Thanks,
amir
icon9.gif  Re: EXPORT ERROR [message #184462 is a reply to message #73981] Wed, 26 July 2006 11:37 Go to previous messageGo to next message
mvillalvazo
Messages: 1
Registered: July 2006
Location: Mexico
Junior Member
hi, im trying to run catexp and catmeta
with these results:

what is wrong with this?

[root@/]# $ORACLE_HOME/rdbms/admin/catmeta.sql
/opt/oracle/product/9.2.0/rdbms/admin/catmeta.sql: line 1: syntax error near unexpected token `('
/opt/oracle/product/9.2.0/rdbms/admin/catmeta.sql: line 1: `Rem Copyright (c) 1987, 2003, Oracle Corporation. All rights reserved. '

[root/]# $ORACLE_HOME/rdbms/admin/catexp.sql
/opt/oracle/product/9.2.0/rdbms/admin/catexp.sql: line 1: Rem: command not found
/opt/oracle/product/9.2.0/rdbms/admin/catexp.sql: line 2: Rem: command not found
/opt/oracle/product/9.2.0/rdbms/admin/catexp.sql: line 3: Rem: command not found
/opt/oracle/product/9.2.0/rdbms/admin/catexp.sql: line 4: syntax error near unexpected token `('
/opt/oracle/product/9.2.0/rdbms/admin/catexp.sql: line 4: `Rem Copyright (c) 1987, 2002, Oracle Corporation. All rights reserved. '

thanks
Re: EXPORT ERROR [message #184465 is a reply to message #184462] Wed, 26 July 2006 12:11 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
First, you are responding to a thread that is dead for about 2 years.
Second,you must run catexp.sql against the database( I mean, logged in into an oracle database as SYSDBA)
Third, please talk to your DBA.
Re: EXPORT ERROR [message #262974 is a reply to message #73394] Tue, 28 August 2007 12:33 Go to previous messageGo to next message
nghump
Messages: 1
Registered: August 2007
Junior Member
Just wanted to thank you. Your resolution worked for me.
noel Cool
Re: EXPORT ERROR [message #263001 is a reply to message #262974] Tue, 28 August 2007 14:02 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
you lucky then Wink
Previous Topic: sqlldr errors
Next Topic: data masker
Goto Forum:
  


Current Time: Thu Dec 08 10:06:19 CST 2016

Total time taken to generate the page: 0.25907 seconds