Re: Quick way to replace an entire database schema?

Galen Boyer <galenboyer_at_yahoo.com> wrote:
>On Fri, 04 May 2001, gamma_at_clark.net wrote:
>
>> I tried creating the schema inside a tablespace, and dropping
>> the tablespace to remove the schema; this takes around 45
>> minutes.
>
>
>drop user SCHEMANAME cascade;
>
>create user ....;
>
>create new ddl.

Right. That's what I was doing before the tablespace approach. It took around 45 minutes, too. (Sorry I didn't mention it; it was several months ago when I last tried this.)

-- 

Paul Brinkley
gamma_at_clark.net