Reverse Engineering My Database

From: <rspeaker_at_my-dejanews.com>
Date: Fri, 29 Jan 1999 18:54:55 GMT
Message-ID: <78t05q$52$1@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 - 12:54:55 CST