Re: find what tables are being used in the database

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Fri, 15 Jun 2007 08:08:22 +0200
Message-ID: <486b2b610706142308x72c41fbct187d3168fe709c24@mail.gmail.com>

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_at_brickstreet.com> 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_at_trivadis.com
http://www.trivadis.com

=========================

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

Received on Fri Jun 15 2007 - 01:08:22 CDT