Purge jorbs and export dataset on SYS.AUD$ table
Hi everyone
I had the sys.aud$ table on another tablespace called "AUDITORIA.dbf"
I want to create a job than purge the data from >30 days.
But before the purge is done, i want to export the dataset of audit
Can anyone help me with this?
I got this script to see the audit logs :
SELECT username,
extended_timestamp,
owner,
os_username,
terminal,
obj_name,
action_name,
sql_text
FROM dba_audit_trail
where timestamp between '17-AUG-2016' and '19-AUG-2016';
Regards,.