Unable to expdp the aud$ table as sys user
Audit tables is size: 5 gb in audit tablespace
Estimate in progress using BLOCKS method...
Total estimation using BLOCKS method: 0 KB
ORA-39166: Object SYS.AUD$ was not found.
ORA-31655: no data or metadata objects selected for job
export is hung for 4hrs and shows 0kb of dumpfile at os levl.
kindly any one please help on this issue.
Pl see this MOS Dochere my intention is taking expdp backup before purging audit table data.
How to Export the AUD$ Table [ID 745540.1]
What exactly are you trying to achieve with this export ?
SCRIPT: Basic example to manage AUD$ table in 11.2 with dbms_audit_mgmt [ID 1362997.1]
How to Truncate, Delete, or Purge Rows from the Audit Trail Table AUD$ [ID 73408.1]
How To Shrink Table AUD$ [ID 1080112.1]