If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

import/export problem

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
-----------------------------------------------------------------

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.