Oracle EXPDP cannot export a specific table under SYS

Source: Internet
Author: User

To create a test table:

D:\app\product\11.1.0\db_1>Sqlplus "/ assysdba "SQL*Plus:release11.1.0.7.0 -Production onSunday May -  -: A: .  theCopyright (c)1982, -, Oracle. Allrights reserved. Connect to: OracleDatabase11g Enterprise Edition Release11.1.0.7.0 -64bitProduction withThe partitioning, OLAP, Data Mining and RealApplication Testing Optionssql> Create TableTest_dump (ID Number, namevarchar2( -) ; The table is created. SQL> SelectT.table_name,tablespace_name,status fromUser_tables TwhereT.table_name like 'test%'; TABLE_NAME Tablespace_name STATUS------------------------------ ------------------------------ --------test_dump SYSTEM Validsql> begin  2   forIinch 1.. -Loop3  Insert  intoTest_dumpValuesI'ABC'||To_char (i)); 4  EndLoop; 5  Commit; 6  End; 7  /PL/The SQL process has completed successfully.

Try exporting:

D:\app\product\11.1.0\db_1>EXPDP \ "Sys/Oracle asSysdba\ "DumpFile=Aduit2.dmp DIRECTORY=Expdump TABLES=Sys.test_dump logfile=Testexp.Log; Export:release11.1.0.7.0 -64bitProduction onSunday -May, the  -: -: -Copyright (c)2003, -, Oracle. Allrights reserved. Connect to: OracleDatabase11g Enterprise Edition Release11.1.0.7.0 -64bitProduction withThe partitioning, OLAP, Data Mining and RealApplication Testing Options Start "SYS". " Sys_export_table_01 ":" SYS/******** as SYSDBA "Dumpfile=aduit2.dmp directory=expdump tables=sys.test_dump logfile=testexp.log; using BLOCKS method to estimate ... Processing object Type Table_export/table/table_data Total estimate for using the BLOCKS method: 0 KBORA-39165: Scenario SYS not found. ORA-39166: Object Test_dump not found. ORA-31655: The data or Metadata object job "SYS" has not been selected for the job. " Sys_export_table_01 "has been completed, but there are 3 errors (completed at 17:18:40)

Find the reason, finally in Oracle's official documentation

Oracle? Database Utilities
Eachg Release 2 (11.2)

Part number e16536-05

Found in

Note:

Several system schemas cannot be exported because they is not user schemas; They contain oracle-managed data and metadata. Examples of system schemas that is not exported include SYS , ORDSYS and MDSYS .

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.