Re: find what tables are being used in the database

On 6/14/07, Hallas, John (EXP N-ARM) <john.hallas_at_lmco.com> 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

--
http://www.freelists.org/webpage/oracle-l