This discussion is archived
6 Replies Latest reply: Apr 2, 2013 6:30 AM by 999256 RSS

Unable to expdp the aud$ table as sys user

999256 Newbie
Currently Being Moderated
Hi ,
oracle 11gr2
os:solaris

Unable to expdp the aud$ table as sys user

Audit tables is size: 5 gb in audit tablespace

error details:

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.

thanks,
visu.
  • 1. Re: Unable to expdp the aud$ table as sys user
    sb92075 Guru
    Currently Being Moderated
    visu996253 wrote:
    Hi ,
    oracle 11gr2
    os:solaris

    Unable to expdp the aud$ table as sys user

    Audit tables is size: 5 gb in audit tablespace

    error details:

    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.

    thanks,
    visu.
    CORRECT!

    expdp does not export any object owned by SYS
  • 2. Re: Unable to expdp the aud$ table as sys user
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Pl see this MOS Doc

    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]

    HTH
    Srini
  • 3. Re: Unable to expdp the aud$ table as sys user
    999256 Newbie
    Currently Being Moderated
    thanks Srini for your reply and MOS doc.
    Pl see this MOS Doc

    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]
    here my intention is taking expdp backup before purging audit table data.
    i will fallow MOS docs as above suggested ,will let you know the results.
  • 4. Re: Unable to expdp the aud$ table as sys user
    KR10822864 Pro
    Currently Being Moderated
    according to your problem it seems to be 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.
    according to oracle documentation it indicates the restriction only on full export mode, but the restriction actually applies to all modes..i hope

    docs.oracle.com
  • 5. Re: Unable to expdp the aud$ table as sys user
    KR10822864 Pro
    Currently Being Moderated
    try to export the table SYS.AUD$ using the traditional export....

    $exp system/<password> file=yourdmpfile.dmp log=yourlogfile.log tables=sys.aud$

    please refer below notes for more info.
    DBMS_AUDIT_MGMT To Manage And Purge Audit Information [ID 731908.1]
  • 6. Re: Unable to expdp the aud$ table as sys user
    999256 Newbie
    Currently Being Moderated
    yes , your correct.traditional export is worked for me .i have taken exp backup sucuessfully without error.
    thanks for all for help.

    Edited by: visu996253 on Apr 2, 2013 6:29 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points