Expdp export error ORA-31693 & ORA-39826
The report library logic has an error:
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) cocould not be resolved.
Baidu deleted the bug because the object was deleted during the export process,
The report library verifies that the object xxx does not exist.
Then I tested it in the local environment and couldn't reproduce the wrong ORA-39826: Direct path load of view or synonym (BI_ETL.WY_CAR_ZJ_UW) cocould not be resolved.
The following is the test process:
1. Create a test table
SQL> create table scott. change_tbs as select * from dba_objects;
Table created.
2. Write an export script
[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. Execute the export script and delete the test table after it starts.
[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,200 9, 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 here;
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
---------------------------- Lili split line ----------------------------
Oracle Import and Export expdp IMPDP details
Solution to Oracle 10g expdp export error ORA-4031
Oracle 10gr2 rac expdp error UDE-00008 ORA-31626
Use of expdp/impdp to back up databases in Oracle
Oracle backup recovery (expdp/impdp)