Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!c03.atl99!rip!news.webusenet.com!newsfeed.telusplanet.net!news1.telusplanet.net.POSTED!53ab2750!not-for-mail
Message-ID: <3E8E2359.C59488FD@telusplanet.net>
From: Hans Forbrich <forbrich@telusplanet.net>
X-Mailer: Mozilla 4.8 [en] (Win95; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.misc
Subject: Re: Oracle Data Dictionary
References: <b6keqm$9sl$1@news.ya.com>
Content-Type: multipart/mixed;
 boundary="------------7DF5DB1F0FFE6CCDEE2FDE93"
Lines: 66
Date: Sat, 05 Apr 2003 00:33:07 GMT
NNTP-Posting-Host: 161.184.143.77
X-Trace: news1.telusplanet.net 1049502787 161.184.143.77 (Fri, 04 Apr 2003 17:33:07 MST)
NNTP-Posting-Date: Fri, 04 Apr 2003 17:33:07 MST
Xref: newsfeed1.easynews.com comp.databases.oracle.misc:95875
X-Received-Date: Fri, 04 Apr 2003 17:32:47 MST (news.easynews.com)
--------------7DF5DB1F0FFE6CCDEE2FDE93
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Derek wrote:

> I want know, what itīs the Oracle data dictionary?

The Data Dictionary is a set of tables, frequemtly accessed through
views, that describes how a set of data is to be manipulated by the
database manager.

> I want his relational schema.

I strongly encourage just looking at it.  You may want it, but if you
take it, it'll break.

> Can somebody help me?

Certainly.

> Thanks.

Sarcasm aside - this question can only be properly answered in the
context of a specific version of the Oracle database, since each version
has a unique dictionary.  You can, however, answer this yourself in
several ways:

1) if you have access to an Oracle installation look at the
$ORACLE_HOME/rdbms/admin/ scripts.  The Oracle dictionary is (was?) in
created using the sql.bsq script and the human-readable dictionary is
(was?) create using the standard.sql script.

2) if you do not have access to the installation, but do have access to
an instance with superuser privs. check the tables and views owned by
SYS

3) if you have access to an instance without SYS priveledges, check out
USER_TABLES, USER_TAB_COLUMNS, and so on

4) Probably best of all, read the docco at http://docs.oracle.com and
especially the Database Administration manual and the SQL Language
Reference manual - the data dictionaries are (were) summarized in the
appendices.

--------------7DF5DB1F0FFE6CCDEE2FDE93
Content-Type: text/x-vcard; charset=us-ascii;
 name="forbrich.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Hans Forbrich
Content-Disposition: attachment;
 filename="forbrich.vcf"

begin:vcard 
n:;
x-mozilla-html:FALSE
url:http://www.ebay.com
adr:;;;;;;
version:2.1
email;internet:Forbrich@telusplanet.net
x-mozilla-cpt:;0
end:vcard

--------------7DF5DB1F0FFE6CCDEE2FDE93--