RE: find what tables are being used in the database

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.
Any table with an index on it is presumably in use (or was at one time)  

Do an analysis of dba_source and try and pull out table names.  

If the db has been running for 10 years then why do you need to document it now?  

John

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jordan Casey Sent: 14 June 2007 15:07
To: oracle-l_at_freelists.org
Subject: find what tables are being used in the database

What is the easiest way to find out what tables are being used in a 10.2.0.2 database? I am using dba_tab_modifications but this only tracks inserts, updates, or deletes. I am trying to document a database that has been running for about 10 years and has over 1500 tables. It has no little integrity constrains and no documentation.    

Thanks.      

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