forbrich_at_telusplanet.net said...
> 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.
>
>
And if you're looking for a traditional ERD, with all the FK
relationships marked, I suspect you'll have to get a job with Oracle
Corp.
--
/Karsten
DBA > retired > DBA
Received on Fri May 23 2003 - 16:12:21 CDT
