From: "Chris Blair" <someone@nowhere.com>
Newsgroups: comp.databases.oracle
Subject: Metadata
Date: Fri, 9 Aug 2002 00:43:59 +0800
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 203.117.58.70
Message-ID: <3d529bb3$1@news.starhub.net.sg>
X-Trace: 9 Aug 2002 00:26:27 +0800, 203.117.58.70
Organization: StarHub Internet Pte Ltd


What is the "best" method for getting complete metadata from a Oracle
(8,8i,9i) database. When I say "complete" I mean not only the objects, but
the defintions of the objects (especially in the case of procedures,
functions, triggers and views - what was the SQL code used to create them).

MS SQL Server uses system tables that contains all of this information. But
from what I can read of the Oracle catalog views, the defintion of much of
the metadata is missing.

Appreciate your advice. (Please reply to the newsgroup as my email address
is false to avoid SPAM).

-- Chris