Hello everyone,

One question please, how mandatory is to use the package DBMS_AUDIT_MGMT for Oracle.

a)There is a NOT ADVISABLE suggestion from Oracle to work in aud$ table directly, to force to use ALWAYS the package.
b) is simple we ADVISE to use the packaeg DBMS_AUDIT_MGMT or
c) we introduced a package to help you IF YOU WANT

Specifically for this tasks.

1) to truncate the sys.aud$, if I need to move a 60gb aud$ and then free space, to use truncate is an acceptable procedure for Oracle?
TRUNCATE TABLE SYS.AUD$;

2) to move records one by one using rowid instad of timestamp

in example
for a in (select rowid from aud$ where timestamp between a and b) loop
insert into aud$_b select * from aud$ where rowid=a.rowid;
dlete from aud$_A where rowid=a.rowid;
commit;
end loop;

Thank you in advance :)