Home » RDBMS Server » Server Utilities » EXP-00056: ORACLE error 31600 encountered
EXP-00056: ORACLE error 31600 encountered [message #73901] Mon, 02 August 2004 01:25 Go to next message
ramya
Messages: 87
Registered: August 2002
Member
hi friends

when i am trying to export the full database i got a error message that export views didnt installed.so i run the catexp.sql and after restarting the export i got this error and export terminated unsuccessfully.i am using oracle9.2.03 and solaris 9.whtether i have to run catpatch.sql or any wrong when runs catexp.i didnt got any error while running catexp

with regards

ramya

. exporting cluster definitions

EXP-00056: ORACLE error 31600 encountered

ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TRANSFORM_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-00056: ORACLE error 31600 encountered

ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TRANSFORM_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
Re: EXP-00056: ORACLE error 31600 encountered [message #73903 is a reply to message #73901] Mon, 02 August 2004 03:54 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
If you have pathced the RBDMS recently from 9.2.0.2 to 9.2.0.3,
THEN
you need to run the catpatch.sql
Re: EXP-00056: ORACLE error 31600 encountered [message #73910 is a reply to message #73903] Mon, 02 August 2004 12:46 Go to previous messageGo to next message
ramya
Messages: 87
Registered: August 2002
Member
is there any way to check whether the pathc 3 is installed for this version
i am using 9.2.0.3.Its already installed before i joins.is there any realtion with this error
that i run catexp. just for some confirmation. i dont thinks so cos its creating the export views
with regards
ramya
Re: EXP-00056: ORACLE error 31600 encountered [message #73919 is a reply to message #73910] Tue, 03 August 2004 03:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
just run the catpatch.sql logged in as sys
Re: EXP-00056: ORACLE error 31600 encountered [message #74619 is a reply to message #73919] Fri, 21 January 2005 11:08 Go to previous message
Christopher Mikos
Messages: 4
Registered: March 2003
Junior Member
Solution works perfectly
Previous Topic: sqlldr loading julian dates
Next Topic: How do you get LICENSE_MAX_SESSIONS (Cambece)
Goto Forum:
  


Current Time: Wed Jul 03 10:59:53 CDT 2024