Re: E-R data dictionary

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Fri, 23 May 2003 20:19:52 GMT
Message-ID: <3ECE8145.9233BC8C@telusplanet.net>

Mosix wrote:

> When can i find the E-R schema about the data dictionary of Oracle ?
>
> Thanks

If you are looking for the descriptions, they are in the documentation - search for "DBA_TABLES". The exact document changes between versions. For Oracle9i Release 2 you would want to look at "Oracle9i Database Reference Release 2 (9.2)"
Part Number A96536-02, chapter 2 "Static Data Dictionary Views"

If you are looking for a wall chart, CA (Computer Associates) used to create one for each version of Oracle as promo for some of their Unicenter admin tools. You could check with them. They are rare but very very useful, and I've only seen them available by talking to a CA rep. Received on Fri May 23 2003 - 15:19:52 CDT