How to get a list of tables, indexes, and views in a given schema

From: dom <dominic.morris_at_eidosnet.co.uk>
Date: 19 Jan 2003 02:02:53 -0800
Message-ID: <c5c9bfea.0301190202.7fe6b8d6_at_posting.google.com>


<newbie>

Hi all,

Following on from my question regarding how to get a list of schemas in a given Oracle DB, I'd like to now know which sys table(s) to query for a list of:

  1. tables
  2. indexes
  3. views

within a given Oracle schema. I guess you can see where I'm going with this...! For each view I'd like to get the text of the view, for each index, the participtating columns, for each table, the columns & their datatypes, sizes, defaults, nullability, etc., triggers & texts.

Many thanks for any advice.
dm.
</newbie>
Received on Sun Jan 19 2003 - 11:02:53 CET

Original text of this message