Re: Drop user takes too long
From: chao_ping <chao_ping_at_163.com>
Date: 23 Dec 2001 01:11:02 -0500
Message-ID: <3c257576$1_at_usenetgateway.com>
Date: 23 Dec 2001 01:11:02 -0500
Message-ID: <3c257576$1_at_usenetgateway.com>
I think it is mainly becauase oracle update system tables about the
dictionary records: the freeup extents, the tables deleted, and so on.
If u are using locally managed tablespace, maybe it will be much faster?
I didnot test it.Just guess.
--
an oracle fan,
an oracle beginner
Posted via dBforums
http://dbforums.com
Received on Sun Dec 23 2001 - 07:11:02 CET