Oracle 中EXP遇到过的错误
使用exp username/pwd@.....
1.第一种错误：
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
解决方法：
SQL>shutdown immediate;
SQL>startup migrate;
SQL>@D:\oracle\ora92\rdbms\admin\catpatch.sql
2.第二种错误：
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
解决方法：
运行一遍catpatch.sql
SQL>shutdown immediate
SQL>startup migrate
SQL>@D:\oracle\ora92\rdbms\admin\catpatch.sql
SQL>shutdown immediate
SQL>startup migrate
执行catpatch.sql大概需要20分钟。
3.第三种错误：
EXP-00056: ORACLE error 19206 encountered
ORA-19206: Invalid value for query or REF CURSOR parameter
ORA-06512: at "SYS.DBMS_XMLGEN", line 83
ORA-06512: at "SYS.DBMS_METADATA", line 345
ORA-06512: at "SYS.DBMS_METADATA", line 410
ORA-06512: at "SYS.DBMS_METADATA", line 449
ORA-06512: at "SYS.DBMS_METADATA", line 1156
ORA-06512: at "SYS.DBMS_METADATA", line 1141
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
解决方法：
运行一遍catpatch.sql
SQL>shutdown immediate
SQL>startup migrate
SQL>@D:\oracle\ora92\rdbms\admin\catmeta.sql
SQL>shutdown immediate
SQL>startup migrate