Expdp export error ORA-31693 & ORA-39826

Source: Internet
Author: User

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)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.