Oracle RAC Database Release 188.8.131.52.0
I want to shrink SYS.AUD$ table. Some records were deleted but table still has about 25GB. I read that it is necessary to move AUD$ segment to another tablespace using dbms_audit_mgmt package.
begin dbms_audit_mgmt.set_audit_trail_location( audit_trail_type => dbms_audit_mgmt.audit_trail_aud_std, audit_trail_location_value => 'AUDTBS'); end;
alter table sys.aud$ enable row movement; alter table sys.aud$ shrink space cascade; alter table sys.aud$ disable row movement;
My questions are:
- Is this "dbms_audit_mgmt.set_audit_trail_location" an ONLINE operation?
- After that, should i move aud$ table back to SYSTEM tablespace?
Thank you guys