Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> find what tables are being used in the database

find what tables are being used in the database

From: Jordan Casey <Casey.Jordan_at_brickstreet.com>
Date: Thu, 14 Jun 2007 10:06:58 -0400
Message-ID: <34A1525E7603124D8AA357C6AEAD73CB0A0CEF50@BMI-MAIL.brickstreet.local> 





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


Received on Thu Jun 14 2007 - 09:06:58 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US