【MOS】EXPDP Fails ORA-39165: Schema SYS Was Not Found (文件 ID 553402.1)

In this Document

APPLIES TO:

SYMPTOMS

DataPump export of table SYS.AUD$ fails with errors:

CAUSE

There is a restriction on dataPump export. It cannot export schemas like SYS, ORDSYS, EXFSYS, MDSYS, DMSYS, CTXSYS, ORDPLUGINS, LBACSYS, XDB, SI_INFORMTN_SCHEMA, DIP, DBSNMP and WMSYS in any mode. The Utilities Guide indicates the restriction only on full export mode, but the restriction actually applies to all modes.

SOLUTION

Export the table SYS.AUD$ using the traditional export:

Other options are:

• Use CTAS (Create Table As Select) to copy the SYS.AUD$ data into a non-restricted schema.
  
  
• Use the DBMS_AUDIT_MGMT package of Audit Vault to manage and purge audit data (see Note 731908.1).
  This allows for the facility to move the AUD$ table out of the SYSTEM tablespace, which can negate the need to export the table.
  
  

REFERENCES