There's also a tool from Embarcadero called ER Studio, which is my personal
recommendation at the moment. I used to recommend ERWin, but then CA
bought it and it has only been lackadaisically maintained since then.
I think there are others...basically any decent ER modelling tool (and
Visio is NOT that) can usually reverse engineer from the data dictionary.
Now, if you don't have your foreign key constraints defined in the
database, you're pretty much out of luck... :-)
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]
"Rao, Maheswara"
<Maheswara.Rao@Sung To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
ardp3.com> cc:
Sent by: Fax to:
[EMAIL PROTECTED] Subject: RE: Oracle 8i database &
ER diagram
06/12/2001 09:15 AM
Please respond to
ORACLE-L
Magesh,
You could use either of the following tools to build your ERD through
reverse engineering.
1. Oracle Designer
2. ERWIN
In my company we use both the above products. I personally prefer using
Oracle Designer due to many reasons (My reasons are irrelevant here for the
purpose of answering your question).
If it is one time job, then you could download either of the products free
(Please check whether you could do reverse engineering with a free
downloaded version).
Rao
-----Original Message-----
Sent: Tuesday, June 12, 2001 7:01 AM
To: Multiple recipients of list ORACLE-L
What about to use Oracle Designer?.
Regards.
Miguel Urosa.
12/06/2001 11.00
"magesh"
[EMAIL PROTECTED]
12/06/2001 11.01
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rao, Maheswara
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).