Database Administration (MOSC)

MOSC Banner

Purge jorbs and export dataset on SYS.AUD$ table

edited Apr 27, 2017 5:01AM in Database Administration (MOSC) 4 commentsAnswered

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,.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center