While you’re trying to export schemas with original export (exp) utility, if export fails with “EXP-00024: Export views not installed, please notify your DBA” message, problem is probably about forgetting to update the catalog metadata which is used by export tool:
1 2 3 4 5 6 7 |
. exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions EXP-00008: ORACLE error 942 encountered ORA-00942: table or view does not exist EXP-00024: Export views not installed, please notify your DBA EXP-00000: Export terminated unsuccessfully |
You can run the following script to create export catalogs but it’s not enough:
1 |
@$ORACLE_HOME/rdbms/admin/catexp.sql |
After running catexp, if you try to export again, you’ll get the following error:
1 2 3 4 5 6 7 8 9 |
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 |
So you shutdown the database, open in migrate mode (or upgrade mode if your DB is 10g+) and patch the catalog:
1 2 3 |
SHUTDOWN IMMEDIATE STARTUP MIGRATE @$ORACLE_HOME/rdbms/admin/catpatch.sql |
Anji Sunkara
Nick
quan
V R Murthy Korimilli
Mijan Tranquil