Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

determine when trigger enabled/disabled

user5716448Nov 25 2016 — edited Nov 25 2016

Hi,

have a 10.2.0.4 database.

Is there a way to determine audit history of a trigger when has been enabled/disabled - could write something manually just wondered if such info anywhere in database

Looked at user objects and it just shows date last amended.

We have some etl which enables/disables a trigger daily but wonderdd if such auditing info aavailabel from database without programming it inside etl to an audit table.

Thnaks

This post has been answered by Gbenga Ajakaye on Nov 25 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 23 2016

Added on Nov 25 2016

#general-database-discussions

7 comments

7,699 views