Export Fails with EXP-00024
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 |