Exp時遭遇 EXP-00008 ORA-00942 EXP-00024 EXP-00000

来源：互联网发布：传奇霸业端源码编辑：程序博客网时间：2024/06/05 02:06

环境：winxp 32bit oracle 9iR2 由9.2.0.1.0升级到 9.2.0.8.0后产生的错误

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user QCSYSTEM
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user QCSYSTEM
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

是沒有Oracle升級为彻底完成所致！
需要重新运行catpatch.sql 解決。

1).停止一切与数据库的连接程序后，SQL> shutdown immediate；

2).在migrate模式启动数据库，执行catpatch.sql存储过程；
SQL> STARTUP MIGRATE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catpatch.sql
SQL> SPOOL OFF

3)再重新启动数据库执行utlrp.sql
SQL> SHUTDOWN
SQL> STARTUP
SQL> @?/rdbms/admin/utlrp.sql

接下来exp命令就可以正常执行了。

0 0