expdp匯出報錯ORA-31693&ORA-39826

expdp匯出報錯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

----------------------------華麗麗的分割線----------------------------

Oracle匯入匯出expdp IMPDP詳解

Oracle 10g expdp匯出報錯ORA-4031的解決方案

Oracle 10gr2 rac expdp 報錯UDE-00008 ORA-31626

Oracle中利用expdp/impdp備份資料庫的使用說明

Oracle備份還原（expdp/impdp）