Home » RDBMS Server » Backup & Recovery » EXP-00056:Oracle error 31600
EXP-00056:Oracle error 31600 [message #271826] Wed, 03 October 2007 01:39 Go to next message
s_majumdar35
Messages: 1
Registered: September 2007
Junior Member
Following error is getting generated when taking EXP backup of Oracle 9i database.

Export of this 9i database(9.2.0.3) fails with"

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

How the error can be solved so that EXP backup can be taken.

Report message to a moderator

Re: EXP-00056:Oracle error 31600 [message #271830 is a reply to message #271826] Wed, 03 October 2007 01:45 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
 
ORA-31600:	invalid input value string for parameter string in
 function string
Cause:	A NULL or invalid value was supplied for the parameter.
Action:	Correct the input value and try the call again.

Report message to a moderator

Re: EXP-00056:Oracle error 31600 [message #271850 is a reply to message #271826] Wed, 03 October 2007 02:56 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You applied a patch without executing catpatch.sql after.
Run this script. Read the patch readme file to know how to execute it.
After, it may be necessary to run one or several among catalog, catproc, catexp and catpatch again.

Regards
Michel

Report message to a moderator

Previous Topic: restore controlfile , and adding tempfile to temp tablespace
Next Topic: How to recover Database with no archive
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 09:38:48 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.