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 .