Re: Quick way to replace an entire database schema?

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.

-- 
Galen
I don't want to be the rock.  Yeah, okay, what do you want to be?
I want to be the piece of glass.