Home » SQL & PL/SQL » SQL & PL/SQL » Need help to Schedule Job to Purge dba_audit_trails along with fga_audit_trail (Unix)
Need help to Schedule Job to Purge dba_audit_trails along with fga_audit_trail [message #674585] Mon, 04 February 2019 06:42 Go to next message
Akmmhto
Messages: 19
Registered: September 2018
Junior Member
Hi team,

I want to schedule a job which will purge
Dba_audit_trail along with fga_audit_trail.

Do u have any steps for this activity.

If yes then pls share...
Re: Need help to Schedule Job to Purge dba_audit_trails along with fga_audit_trail [message #674587 is a reply to message #674585] Mon, 04 February 2019 07:36 Go to previous messageGo to next message
Michel Cadot
Messages: 66475
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL
and
DBMS_AUDIT_MGMT.SET_PURGE_JOB_INTERVAL

[Updated on: Tue, 05 February 2019 06:27]

Report message to a moderator

Re: Need help to Schedule Job to Purge dba_audit_trails along with fga_audit_trail [message #674602 is a reply to message #674587] Tue, 05 February 2019 06:06 Go to previous message
Akmmhto
Messages: 19
Registered: September 2018
Junior Member
Thankyou Michel, Document was perfect
Previous Topic: Account number selection from 10 parallel session
Next Topic: Issue in dynamic sql.
Goto Forum:
  


Current Time: Tue Jul 23 19:53:26 CDT 2019