Каморка

Vovchik писал(а): ПРо базу известно то, что она была импортирована из другой. Т.е. - сделал полный экспорт одной базы а потом в другой базе сделал полный импорт. Обе базы - Оракл 92 и теперь экпорт не желает работать. Поубивав бы...

Article-ID: <Note:232120.1>
Circulation: PUBLISHED (EXTERNAL)
Folder: server.Utilities.ExportImport
Topic: Known Problems
Title: ORA-31600: invalid input value EMIT_SCHEMA for parameter
NAME in function SET_TRANSFORM_PARAM
Document-Type: PROBLEM
Impact: LOW
Skill-Level: NOVICE
Server-Version: 09.02 to 09.02
Updated-Date: 31-MAR-2003 11:30:28
Attachments: NONE
Content-Type: TEXT/PLAIN
Keywords: 31600; EXP-00000; EXP-00056; EXP-56; ORA-06512; ORA-31600;
ORA-6512;
Products: 5/RDBMS;
Platforms: GENERIC;

Symptom(s)
~~~~~~~~~~
You are performing a database export against your 9.2 database. The database
export abnormally ends with the following errors:

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.