报表库逻辑备有一个错误：ora-31693: table data object bi_etl.xxx failed to load/unload and is being skipped due to er
报表库逻辑备有一个错误：
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）
本文永久更新链接地址：