OraFAQ Forum: Server Utilities » HELP! Error 31600 when export oracle data

Home » RDBMS Server » Server Utilities » HELP! Error 31600 when export oracle data

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

HELP! Error 31600 when export oracle data [message #73020]

Sat, 17 January 2004 09:51

Howard Li
Messages: 1
Registered: January 2004

Junior Member

Env: Solaris 2.8; Oracle 64-bit 9.2.0.3

When trying to do exp $DBUSER/$DBPWD@$DBNAME file=back.dmp log=exp.log, I got following error
===========================
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
==============================================

Then I try to execute catexp.sql with sys account, and rerun the export again(Is this step right? I got this info from others). This time it reports following error message.
===================================================
EXP-00056: ORACLE error 31600 encountered
ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TR
ANSFORM_PARAM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA_INT", line 3926
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4050
ORA-06512: at "SYS.DBMS_METADATA", line 836
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
===================================================

Can anybody give me a hand? Thanks much!!

Report message to a moderator

Re: HELP! Error 31600 when export oracle data [message #73021 is a reply to message #73020]

Sat, 17 January 2004 22:02

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Hi,

Also try to run catalog.sql and catproc.sql:

connect sys as sysdba  
spool report  
@?/rdbm/admin/catalog.sql  
@?/rdbm/admin/catproc.sql  
spool off

Best regards.

Frank

Report message to a moderator

Re: HELP! Error 3160 when export oracle data [message #73192 is a reply to message #73021]

Fri, 27 February 2004 07:30

WL
Messages: 1
Registered: February 2004

Junior Member

thanks a LOT!!!! i just screwed my WHOLE DB!!!!

p.s.: you should just run catexp.sql only!

Report message to a moderator

Previous Topic:	SQL*Loader-412: More columns specified for table LOAD than the maximum (254)
Next Topic:	OCP Exam

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 05:28:46 CDT 2024