Re: The fastest way of droping a schema???

On Wed, 18 Apr 2001, agonzalezsanQUITA_at_ESTOnexo.es wrote:

> The objects of an user, the user, the defaut tablespace and the
> datafiles asociated. I usually use the "DROP USER XXX CASCADE
> CONSTRAINTS",
This only drops the user and its objects not the tablespace and files associated.

> etc but it's very slow. Do you know some other way??

I don't but maybe someone else does?

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