$ 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]