Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Recreate database script

RE: Recreate database script

From: Kevin Lange <kgel_at_ppoone.com>
Date: Mon, 09 Sep 2002 10:33:20 -0800
Message-ID: <F001.004CB34F.20020909103320@fatcity.com>


I have used Visio to do that .

It links the tables together if they have foreign/primary keys. If you have no relations like that then it will at least list all the tables you pick.

-----Original Message-----
Sent: Monday, September 09, 2002 12:09 PM To: Multiple recipients of list ORACLE-L

> Could anyone here suggest a software package that can create an ER
> diagram by simply connecting to an Oracle database, reverse engineer
> it to see the schema in an ER diagram - instead of in a file with
> ddl/dml statements.

I haven't tested it, but Microsoft Visio 2000 claims to be able to reverse engineer a database.

Gary Chambers

//-------------------------------------
// Lucent Technologies GIO/Unix
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)

// Nothing fancy and nothing Microsoft
//-------------------------------------

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gary Chambers
  INET: gc22_at_lucent.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: Kevin Lange
  INET: kgel_at_ppoone.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 Mon Sep 09 2002 - 13:33:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US