Re: Reverse engineering on ORACLE

From: Phil Cook <pncook_at_worldnet.att.net>
Date: 1997/12/18
Message-ID: <67a18n$7ri@bgtnsc02.worldnet.att.net>#1/1

Designer 2000 is capable of reverse engineering an Oracle database as well as a number of other tools on the market, Erwin, for example.

The main issue with reverse engineering is referential integrity. If you have not implemented primary and foreign keys then the tool will not know if the tables are related.

The relationship between stored procedures and tables can also be interpreted, see the dba_dependencies table. Designer 2000 can do all of this, but reverse engineering a database with hundreds or more tables can take quite some time especially if you are using alot of triggers and stored procedures.

Phil Cook
Certified Oracle DBA Received on Thu Dec 18 1997 - 00:00:00 CST