OraFAQ Forum: Backup & Recovery » EXP-00056:Oracle error 31600

Home » RDBMS Server » Backup & Recovery » EXP-00056:Oracle error 31600

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

EXP-00056:Oracle error 31600 [message #271826]

Wed, 03 October 2007 01:39

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

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

Michel Cadot
Messages: 68653
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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 17:06:16 CDT 2024