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!

How to find what tables are getting audit in a db

IndianDBAJul 23 2014 — edited Jul 23 2014

I want to find the lis of tables which are getting audited, i am lets say my privious DBA setup audit enable for 100 tables, some of the tables are generating audit information but most of the tables in this 100 are not in use as of now so they are not generating audit information.

But i want to find all the tables which my privious DBA enabled audit, is there any view exists which shows the list of all tables which are setuped for Audit.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 20 2014

Added on Jul 23 2014

#general-database-discussions

2 comments

1,779 views