ORACLE导出时出错解决方法汇总

正常的导入，导出不失为检测数据库是否正常安装的一个方法 

 

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

是沒有乾淨升級至9204所至！
重新運行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.

This will resolve issue.

 

===================================================

exp过程中遇到ORA-31600问题的解决

解决办法是运行一遍catpatch.sql。于是，按照文章说的步骤，做如下操作：

shutdown immediate
startup migrate
@/usr/ORACLE/u01/app/oracle/product/9.2.0/rdbms/admin/catpatch.sql
shutdown immediate
startup

其中，执行catpatch.sql的部分大约持续15分钟左右。执行完毕之后，问题解决

====================================================

 

ORA-01747: user.table.column, table.column 或列说明无效

字段中列名有Oracle的关键字

select * from v$reserved_words 可以查看Oracle 有哪些关键字。

如果是这样，在执行操作的时候字段需要使用双引号括上，例如：
update table1 a set a."level" = '01' ;