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>
Date: 19 Jan 2003 02:02:53 -0800
Message-ID: <c5c9bfea.0301190202.7fe6b8d6_at_posting.google.com>
<newbie>
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:
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.
Hi all,
dm.
</newbie>
Received on Sun Jan 19 2003 - 11:02:53 CET