当前位置:  数据库>oracle

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

    来源: 互联网  发布时间:2017-06-16

    本文导语: 报表库逻辑备有一个错误: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 dataORA-39826: Direct path load of view or synonym (BI_ETL.xxx) could not be resolved. 百度了一下,是因为这个对...

报表库逻辑备有一个错误:
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

----------------------------华丽丽的分割线----------------------------

Oracle导入导出expdp IMPDP详解

Oracle 10g expdp导出报错ORA-4031的解决方法

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626

Oracle中利用expdp/impdp备份数据库的使用说明

Oracle备份还原(expdp/impdp)


    
 
 

您可能感兴趣的文章:

 
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。












  • 相关文章推荐
  • 基于oracle expdp命令的使用详解


  • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除!

    ©2012-2021,,E-mail:www_#163.com(请将#改为@)

    浙ICP备11055608号-3