Re: 8i or 9i download data dictionary?

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Tue, 16 Jul 2002 06:05:03 +1000
Message-ID: <agv9s6$kto$1@lust.ihug.co.nz>

Er, why do you want to download a data dictionary? The data dictionary describes the contents of a database. As such, every data dictionary is unique, and only of relevance to the database from which it came. So if you *could* download a data dictionary, it would be about as much use as a hit on the head with a wet mackerel.

If you mean 'downloading information *about* the data dictionary', that's a very different matter. Do a select * from dictionary to start with -that lists all the views on the data dictionary tables.

Or you could connect as SYS and then do a select * from user_tables -that will list all the underlying tables themselves of the data dictionary.

Or you could look at technet.oracle.com and read documentation about the data dictionary.

Regards
HJR "news.verizon.net" <vze4927p_at_verizon.net> wrote in message news:t3BY8.4984$2v1.4746_at_nwrddc01.gnilink.net...
> Is there a site to download the data dictionary?
>
> Thanks
>
> rmartes
>
>
Received on Mon Jul 15 2002 - 15:05:03 CDT