I am running oracle 9.2.0.4 on solaris8. I am exporting all and is getting the following error message.
#su - oracle
$exp system/manager file=oracle_1127_clear.dmp full=y indexes=y consistent=y log=oracle_1127_clear.log
export: Release 9.2.0.4.0 - Production on Sun Nov 27 19:23:54 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
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
The export views are not correctly installed. Try doing this:
run following script:
1).Login in as sys user.
2).run the $ORACLE_HOME/rdbms/admin/catexp.sql file. This will recreate all your exp related views.
3).run the exp again.
This will resolve issue.
博主在Solaris 8系统上运行Oracle 9.2.0.4导出数据时遇到错误,提示表或视图不存在、导出视图未安装。解决办法是登录sys用户,运行$ORACLE_HOME/rdbms/admin/catexp.sql文件重新创建导出相关视图,再重新执行导出操作。
2523

被折叠的 条评论
为什么被折叠?



