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.


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.
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: 64151
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.

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


Current Time: Fri Dec 09 15:34:36 CST 2016

Total time taken to generate the page: 0.18854 seconds