6 Replies Latest reply: Apr 2, 2013 8:30 AM by 999256 RSS

    Unable to expdp the aud$ table as sys user

    999256
      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
          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
            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
              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
                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
                  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
                    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