Re: 8i or 9i download data dictonary?
From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 15 Jul 2002 15:12:12 GMT
Message-ID: <3D32E615.D1AF8FB3_at_exesolutions.com>
Date: Mon, 15 Jul 2002 15:12:12 GMT
Message-ID: <3D32E615.D1AF8FB3_at_exesolutions.com>
"news.verizon.net" wrote:
> Is there a site to download the data dictionary?
>
> Thanks
>
> rmartes
There is no such things as "the data dictionary" in the sense you appear to be using it.
The data dictionary, depending upon how one uses the term, is a collection of tables and views. If you want the definitions of those objects go to $ORACLE_HOME/rdbms/admin and look in the file SQL.BSQ, catalog.sql, and catproc.sql. You can also spool off the results of statements such as:
SELECT object_name
FROM dba_objects
WHERE ....;
If you want the contents of the tables ... I don't even want to go
there.
Daniel Morgan Received on Mon Jul 15 2002 - 17:12:12 CEST