Re: 8i or 9i download data dictionary?

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<agv9s6$kto$1_at_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
> >

Perhaps they mean the Oracle Repository product usually referred to as Designer. I haven't been to technet in a while but at one time you could locate trial versions of many Oracle products for downloading through the site so perhaps it would be worth a look.

If they want information about the Oracle rdbms dictionary then besides the Oracle version# Reference Manual they might want to check out the Cooperative FAQ at
http://www.jlcomp.demon.co.uk/faq/ind_faq.html as there are a couple of basic articles on the subject that will help a new person.

• Mark D Powell --