Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
SYMPTOMS
DataPump export of table SYS.AUD$ fails with errors:

ORA-39165: Schema SYS was not found.
ORA-39166: Object AUD$ was not found.
ORA-31655: no data or metadata objects selected for job
Job "SYS"."SYS_EXPORT_TABLE_01" completed with 3 error(s) at 13:49:47

CHANGEShttp://www.cndba.cn/hbhe0316/article/108026http://www.cndba.cn/hbhe0316/article/108026http://www.cndba.cn/hbhe0316/article/108026

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:http://www.cndba.cn/hbhe0316/article/108026http://www.cndba.cn/hbhe0316/article/108026

#exp system/<password> file=dumpfile.dmp log=logfile.log tables=sys.aud$

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.http://www.cndba.cn/hbhe0316/article/108026

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle