OraFAQ Forum: SQL & PL/SQL » Need help to Schedule Job to Purge dba_audit_trails along with fga_audit

Home » SQL & PL/SQL » SQL & PL/SQL » Need help to Schedule Job to Purge dba_audit_trails along with fga_audit_trail (Unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need help to Schedule Job to Purge dba_audit_trails along with fga_audit_trail [message #674585]

Mon, 04 February 2019 06:42

Akmmhto
Messages: 38
Registered: September 2018

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

Report message to a moderator

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

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

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

Akmmhto
Messages: 38
Registered: September 2018

Member

Thankyou Michel, Document was perfect

Report message to a moderator

Previous Topic:	Account number selection from 10 parallel session
Next Topic:	Issue in dynamic sql.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 16 19:36:35 CST 2026