expdp导出报错ORA-31693&ORA-39826

最新推荐文章于 2023-10-31 17:04:54 发布

原创最新推荐文章于 2023-10-31 17:04:54 发布 · 1.2w 阅读

5 ·

CC 4.0 BY-SA版权

文章标签：

#expdp #ORA-31693 #ORA-39826 #oracle

Oracle 专栏收录该内容

68 篇文章

订阅专栏

本文详细介绍了在使用Oracle导出脚本时遇到的ORA-31693和ORA-39826错误，通过验证对象存在性并重新创建测试表来解决问题的过程，提供了重现错误的方法和解决方案。

报表库逻辑备有一个错误：
ORA-31693: Table data object "BI_ETL"."xxx" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-39826: Direct path load of view or synonym (BI_ETL.xxx) could not be resolved.

百度了一下，是因为这个对象在导出过程中被删掉了导致的bug，
去报表库验证了一下对象xxx确实不存在

然后在本地环境测试了一下，没有能重现错误ORA-39826: Direct path load of view or synonym (BI_ETL.WY_CAR_ZJ_UW) could not be resolved.
下面是试验过程：
1、创建张测试表
SQL> create table scott.change_tbs as select * from dba_objects;

Table created.

2、编写导出脚本
[oracle@localhost exp_dir]$ vi expdp_test.par
userid='/ as sysdba'
DIRECTORY=dump_dir
DUMPFILE=EXPDP_test.dmp
CONTENT=all
LOGFILE=expdp_20141126.log
TABLES=scott.change_tbs

3、执行导出脚本，开始后删除测试表
[oracle@localhost exp_dir]$ expdp parfile=expdp_test.par

Export: Release 11.2.0.1.0 - Production on Wed Nov 26 14:48:58 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."SYS_EXPORT_TABLE_01": /******** AS SYSDBA parfile=expdp_test.par
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 9 MB /*这里drop table scott.change_tbs;

ORA-31693: Table data object "SCOTT"."CHANGE_TBS" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-00942: table or view does not exist
Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TABLE_01 is:
/home/software/exp_dir/EXPDP_test.dmp
Job "SYS"."SYS_EXPORT_TABLE_01" completed with 1 error(s) at 14:49:06

参考：
http://blog.mchz.com.cn/?p=10401