Thanks for the question, Juan Carlos.
Asked: December 05, 2016 - 3:07 pm UTC
Last updated: December 05, 2016 - 4:59 pm UTC
Version: 12 11
Viewed 1000+ times
You Asked
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 :)
and Connor said...
Obviously there are lots of databases out there that will have scripts that are managing aud$ manually.
In my opinion, I'd be moving to DBMS_AUDIT_MGMT where possible because as security becomes a more high profile topic, the auditing requirements become more complex. So it may well be the case that we might introduce lots of new objects, structures etc to manage auditing.
DBMS_AUDIT_MGMT would know about these - your scripts may not.
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment