There are a large number of tools available to do this. This was discussed
just recently on the list. Check the archives.

I prefer dbdesigner4 from www.fabforce.net

bastien


----- Original Message -----
From: "Choudhry Deepak "
<oracledba-ezmlmshield-x75060266.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, May 03, 2005 6:26 AM
Subject: Data Modelling


> Hi Gurus,
>
> I want to find the data model of particular database.
> Is this Possible?
>
> Thanks in Advance
>
> Deepak Choudhary
>
>
> -----Original Message-----
> From: LAUWERYSEN Erwin
> [mailto:oracledba-ezmlmshield-x69811615.[Email address protected]
> Sent: Tuesday, May 03, 2005 3:01 PM
> To: LazyDBA Discussion
> Subject: RE: Data Dictionary
>
> Perhaps something like this?
>
> select * from user_constraints where constraint_type in ('R','P') and
> table_name in (.....)
>
> R is relational key p is primary key
>
> Erwin
>
>
> -----Original Message-----
> From: Choudhry Deepak [mailto:oracledba-ezmlmshield-x99590646.[Email
> address protected]
> Sent: dinsdag 3 mei 2005 9:39
> To: LazyDBA Discussion
> Subject: Data Dictionary
>
> Hi Gurus,
>
> I have tables Table A Table B and Table C .
>
> I want to find the relationship can I do that ?
>
> Which are the data dictionary will provide me the information
>
> Thanks In Advance
>
> Deepak Choudhary
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
> see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com By using this list you agree
> to these terms:http://www.lazydba.com/legal.html
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>



Oracle LazyDBA home page