Re: Quick way to replace an entire database schema?

You can backup your whole database before loading schema, then when you need to reload it, you will have just to restore database from backup.
As I understood, you have only one schema in database, otherwise I would recommend to create a separate database for this schema.

Regards,
Edward

"Gamma" <gamma_at_clark.net> wrote in message news:MvEI6.3857$DW1.180773_at_iad-read.news.verio.net...
>
> I am working on a large, complex schema, that is prone to error.
> One of my major problems is the length of time required to remove and
> reload the schema; deleting and re-creating the database using the
> Oracle Database Configuration Assistant takes about 15-30 minutes.
> There's no data in any of the tables, and in fact, nothing in the
> database at all, other than this schema.
>
> I tried creating the schema inside a tablespace, and dropping the
> tablespace to remove the schema; this takes around 45 minutes.
>
> Is there a faster way to do what I'm doing?
>
> Thanks in advance for any suggestions.
>
> --
>
> Paul Brinkley
> gamma_at_clark.net
>
Received on Mon May 07 2001 - 13:25:52 CDT