Hi I am trying to audit the database for looking at table usage and then cleaning up tables not being used.
I issued the commands
audit update table, select table
audit delete table
audit insert table
audit drop any table
audit create table
I have not set the audit_trail to TRUE yet that is to done on sunday on scheduled shutdown of database, I want to know is there any view I can query now to see which objects will be audited when database starts up after sunday?
Thanks in advance
Click Here to Expand Forum to Full Width