-
import/export problem
good morning
I'm experiencing a weird problem with my export dumps...or the lack of it.
I'm getting an error i've never seen before in the exp utl.I've done many imports & export over the past 3 years, but never this...
Is there a "cat" script that I can run or anything else to rectify this problem. I'm on windows 2000 proffesional,Oracle 9.2.0.4
----------------------------------------------------------------
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
-----------------------------------------------------------------
thnx in advance
-
This is from Metalink:
Note:232120.1
Subject: ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TRANSFORM_PARAM
Change(s)
~~~~~~~~~~
One of the known causes for the error above is that a patchset was recently applied to the database but one or more of the patchset steps were not performed.
Cause
~~~~~~~
View the readme notes for the patchset recently installed. You will see a step that should have been performed that directs you to run the script named catpatch.sql. Very likely this step was never performed.
Fix
~~~~
As the sysdba user run the catpatch.sql script found in the directory named $ORACLE_HOME/rdbms/admin. Before you submit this script, view it's contents. You may see that this script places the database in restricted mode.
Thanks,
Sesha.
--------------------------------------------------------------------------------
From: Oracle, Sam Perciasepe 14-Jan-04 12:57
Subject: Re : Ora-31600 encountered during Export
Hi Richard,
As Sesha has already pointed out, you are encountering the issue as described in Note:232120.1
Article-ID:
Title: ORA-31600: invalid input value EMIT_SCHEMA for
parameter NAME in function SET_TRANSFORM_PARAM
Document-Type: PROBLEM
It appears that the Postinstall Actions were not completed after the 9.2.0.4 patch set was applied.
So the solution is:
1) Cleanly shutdown the database.
2) Connect to the database using the SYS/password as SYSDBA account.
3) Startup the database using command:
STARTUP MIGRATE <<< This starts up the database in restricted mode.
4) Run the catpatch.sql script from the $ORACLE_HOME\rdbms\admin directory.
5) Cleanly shutdown the database.
6) Startup the database with the command:
STARTUP
7) Perform another export of the database.
This should resolve the errors being encountered.
Regards,
Sam.
HOPE THIS HELPS