DBCA創建的數據庫exp問題

$ exp userid="'"sys/password as sysdba"'" file=pm.dmp log=pm.log owner=pm buffer=1024000

Export: Release 9.2.0.8.0 - Production on Wed Aug 14 17:04:35 2013

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

Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Export done in UTF8 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 PM
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user PM
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

原因：使用DBCA創建的數據庫沒有安裝導出視圖

解決方法

     用有DBA權限的用戶運行$ORACLE_HOME/rdbms/admin下的catexp.sql腳本即可

參考metalink ID904954.1

Error: "EXP-00024: Export views not installed, please notify your DBA", when trying to export schema to a dmp file [ID 904954.1]