RE: Oracle 8i database & ER diagram

From: <Diana_Duncan_at_ttpartners.com>
Date: Tue, 12 Jun 2001 07:13:20 -0700
Message-ID: <F001.00325724.20010612070126@fatcity.com>

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: Diana_Duncan_at_ttpartners.com

                                                                                       
                                  
                    "Rao, Maheswara"                                                   
                                  
                    <Maheswara.Rao_at_Sung        To:     Multiple recipients of list 
ORACLE-L <ORACLE-L_at_fatcity.com>       
                    ardp3.com>                 cc:                                     
                                  
                    Sent by:                   Fax to:                                 
                                  
                    root_at_fatcity.com           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.

Oracle Designer
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"
magesh_at_garoo.ne.jp
12/06/2001 11.01

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rao, Maheswara
  INET: Maheswara.Rao_at_Sungardp3.com

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: ListGuru_at_fatcity.com (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: Diana_Duncan_at_ttpartners.com

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: ListGuru_at_fatcity.com (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).

Received on Tue Jun 12 2001 - 09:13:20 CDT