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
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( 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.

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
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.
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: 63924
Registered: March 2007
Location: Nanterre, France, http://...
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.

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

Current Time: Wed Oct 26 04:46:26 CDT 2016

Total time taken to generate the page: 0.10766 seconds