Re: dropping a schema too slow???

L. Tseng wrote:
>
> Is droppingschema a really slow process?
> It does not quite make sense to me that dropping a relative small schema would take
> 15-20 minutes.
>
> I have a schema which contains about 20 MB data. Using
>
> drop user schemaname/username cascade;
>
> often takes 15-20 minutes. This is on NT 4.0/Pentinum Pro200.
>
> Is there any other way to speed up this?
>
> Thank you.
>
> Leslie

Have you tried disabling and/or dropping the schema constraints and triggers on the objects first? This may speed things up. Give it a try.

Steve Phelan. Received on Tue Mar 25 1997 - 00:00:00 CET