I was also thinking of auditing but was looking for other possible solutions. I did not think of turning on index monitoring, that may help also. Thanks. ________________________________ From: Hallas, John (EXP N-ARM) [mailto:john.hallas@xxxxxxxx] Sent: Thursday, June 14, 2007 10:22 AM To: Jordan Casey; oracle-l@xxxxxxxxxxxxx Subject: 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jordan Casey Sent: 14 June 2007 15:07 To: oracle-l@xxxxxxxxxxxxx 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.