Re: find what tables are being used in the database

On 6/14/07, Hallas, John (EXP N-ARM) <john.hallas@xxxxxxxx> wrote:


 Auditing is probably  the best get, although there may be monthly, annual
or ad-hoc tables that might take a time to appear in the audit tables.




Auditing is by far the simplest method to do this.

All that needs to be recorded is the fact that one of SELECT,INSERT,DELETE
or UPDATE
were performed on a table.


--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: