Re: Reverse Engineering My Database

If you can afford three grand take a look at ERwin. It will probably do what you want.

Van

rspeaker_at_my-dejanews.com wrote in message <78t05q$52$1_at_nnrp1.dejanews.com>...
>Hi All --
>
>I am running Oracle 8.0.4 on AIX 4.2.1. There have been too many hands in
the
>pot for the creation of my database, and the modifications to it from
>developers.
>
>In a nutshell, what I want to do is somehow, generate the SQL code to
rebuild
>my database to it's current state at any time. I know I can use the export
>tool, answering NO to export data? and get just the schema. However, I
don't
>think this rebuilds any of my tablespaces. It does appear to rebuild all
the
>tables, indexes, and constraints, but builds them in my default tablespace
if
>the targetted tablespace does not exist. I currently have over 300
>tablespaces, and growing regularly, so I don't want to rely on a
>create_tablespace script that I have to keep updating to keep current.
>
>Anyone have any suggestions?
>
>Thanks
>Roy
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Jan 29 1999 - 20:23:41 CST