sys.col_usage$ might be yet another way, as 10gr2 per default tracks the columns being used in queries as predicates, and stores it in there. Stefan On 6/14/07, Jordan Casey <Casey.Jordan@xxxxxxxxxxxxxxx> wrote:
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.
-- ========================= Stefan P Knecht Consultant Infrastructure Managed Services Trivadis AG Europa-Strasse 5 CH-8152 Glattbrugg Phone +41-44-808 70 20 Fax +41-808 70 12 Mobile +41-79-571 36 27 stefan.knecht@xxxxxxxxxxxx http://www.trivadis.com =========================