Export失敗

[oracle@sent02 oracle]$ ./exp.sh

Export: Release 9.2.0.4.0 - Production on Fri May 23 09:02:44 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
Export done in ZHT16BIG5 character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user John
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user John
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 DB是從9.2.0.1昇級到9.2.0.4，某些EXP需要的字典没有被升级所以造成錯誤，
解決方法與9.2.0.4昇級到.2.0.7一樣，執行 rdbms/admin/catexp.sql 就可以了

SQL> ?@rdbms/admin/catexp.sql