Export: Release 9.2.0.5.0 - Production on Thu Aug 14 10:08:45 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user UEP
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user UEP
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
Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user UEP
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user UEP
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 9.2在WINDOW下导出的DMP文件在CentOS5.1平台上导入Oracle 10.2中时有警告,在导入过程中该注意些什么?sqlplus连接不上10g的
- 行列转置的问题 有点难度!
- [100分]Oracle性能优化的问题
- 求助一个简单的pl/sql语句,报错:内存不够。
- 用循环该怎么写?
- oracle新创建的用户无法登录。
- 请大家看看下面问题是不是由于CURSOR使用没有关闭,最后耗尽Oracle内存引起的!发表意见的都给分
- oracle共享内存问提
- 祈求oracle查询语句
- 紧急求救 oracle 监听器启动不了
- oracle的联合查询 郁闷~~~~~~~
重新運行catexp.sql 解決。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.
解决办法:
以/as sysdba的方式登路数据库,
重新运行catexp.sql脚本.
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.