find what tables are being used in the database

  • From: "Jordan Casey" <Casey.Jordan@xxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 14 Jun 2007 10:06:58 -0400

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.

 

 

 

Other related posts: