reverse engineer a database

Hope someone can help...

I have inherited an Oracle based project that is composed of 170 or so tables and loads of other objects (indexes, views, sequences, triggers, ...). The initial database design has been changed/modified quite a bit over the past few years, and there is little to no documentation. In fact, there are no scripts to create the objects. The way the database is populated is to import a majority of the objects and then run sql scripts to update with the latest changes.

I would like to be able to reverse engineer the database and create the necessary scripts to build it from scratch.

My questions are ...

   Are there existing tools (Oracle Designer?) that can help    with this process?

   If so, what is the best tool for the job? Any tips on what    to avoid?

The database was originally Oracle 7, but we have migrated it to Oracle 8 on an HP-UX platform. We would like to run the tools from either HP-UX or Windows NT. I am in digest mode, so please reply to me directly (as well as to the list). Thanks very much for any help in this area.

John Armani
ABB Industrial Systems, Inc
armani_at_armani.rochny.uspra.abb.com Received on Wed May 31 2000 - 10:42:47 CDT