Re: Oracle Data Dictionary

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.
   • text/x-vcard attachment: Card for Hans Forbrich