Oracle Technology‎ > ‎Database‎ > ‎database notes‎ > ‎

DBMS_AUDIT_MGMT

posted 31 Dec 2008, 01:01 by Alan Nolan-Davies   [ updated 22 Jul 2011, 07:32 ]
Oracle recommend using the DBMS_AUDIT_MGMT package to move the sys.aud$ table from the System Tablespace to another.

I created a new Tablespace called AUDIT_DATA and then ran this procedure.

SQL> begin
  2  DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION(
  3  audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_DB_STD,
  4  audit_trail_location_value => 'AUDIT_DATA');
  5  end;
  6  /

PL/SQL procedure successfully completed.

it's simple and it works... nice