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

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 18 Apr 2001 22:59:25 -0700
Message-ID: <3ADE7EBD.C16C8ED0@exesolutions.com>

The fastest way, provided you have set up your database with this in mind and have different schemas using different tablespaces try:

DROP TABLESPACE tablespace_name INCLUDING CONTENTS.

If you have multiple schemas sharing a tablespace do not do this unless you are ready to look for another job.

Daniel A. Morgan

Alvin wrote:

> I'd like to know the fastest way of droping a schema, that's to say: The
> objects of an user, the user, the defaut tablespace and the datafiles
> asociated.
> I usually use the "DROP USER XXX CASCADE CONSTRAINTS", etc but it's very
> slow.
> Do you know some other way??
> Thank in advance and sorry for my english.
Received on Thu Apr 19 2001 - 00:59:25 CDT