dropping a schema too slow???

From: L. Tseng <lesliet_at_u.washington.edu>
Date: 1997/03/25
Message-ID: <5h74vu$nb1_at_nntp1.u.washington.edu>#1/1


[Quoted] 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 Received on Tue Mar 25 1997 - 00:00:00 CET

Original text of this message