import/export problem

[robertbalmer]

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

[liorjsb]

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