Exp時遭遇 EXP-00008 ORA-00942 EXP-00024 EXP-00000
来源:互联网 发布:班车路线查询软件 编辑:程序博客网 时间:2024/06/11 03:55
Exp時遭遇 EXP-00008 ORA-00942 EXP-00024 EXP-00000
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user QCSYSTEM
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user QCSYSTEM
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升級为彻底完成所致!
需要重新运行catpatch.sql 解決。
1).停止一切与数据库的连接程序后,SQL> shutdown immediate;
2).在migrate模式启动数据库,执行catpatch.sql存储过程;
SQL> STARTUP MIGRATE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catpatch.sql
SQL> SPOOL OFF
3)再重新启动数据库执行utlrp.sql
SQL> SHUTDOWN
SQL> STARTUP
SQL> @?/rdbms/admin/utlrp.sql
接下来exp命令就可以正常执行了。
- Exp時遭遇 EXP-00008 ORA-00942 EXP-00024 EXP-00000
- Exp時遭遇 EXP-00008 ORA-00942 EXP-00024 EXP-00000
- EXP
- exp
- EXP
- exp
- exp
- exp
- exp
- EXP
- exp报EXP-00008,ORA-00904的错误
- ORA-00904 & EXP-00091
- exp ORA-01455
- ORA-00904 & EXP-00091
- Oracle11g EXP ORA-01455
- oracle 11g exp 报错 EXP-00056;ORA-12154;EXP-00000;
- 【EXP】exp-00091解决办法
- Oracle 导出错误 EXP-00000~EXP-00107
- 【探索wireshark】 熟悉GTK+
- 在Eclipse中构建Heritrix1.14.4
- ldd查看依赖关系
- MIME邮件格式分析及信息提取
- 用SecureCRT来上传和下载数据
- Exp時遭遇 EXP-00008 ORA-00942 EXP-00024 EXP-00000
- Ubuntu下配置一个高效的PHP开发环境GVIM
- C/C++函数调用时的参数传递小结
- 计算机仿真中的HLA技术 (第四章读书笔记)
- vc鼠标移动改变字体颜色
- 读取并修改App.config文件(转载)
- poj1042解题报告
- 解决 xx is not in the sudoers file
- 写在TWU之前