Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Recreate database script
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)
//-------------------------------------
-- 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