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: 65155
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: How to recover Database with no archive
Next Topic: ASM Backup
Goto Forum:

Current Time: Thu Aug 24 00:13:23 CDT 2017

Total time taken to generate the page: 0.04984 seconds