Oracle-L: Re: Dropping a tablespace

From: Murray Kaiser 6194 <Murray.Kaiser_at_NSPOWER.NS.CA>
Date: Wed, 17 Jan 1996 12:43:54 -0400
Message-Id: <9601171725.AA11119@alice.jcc.com>

<snip>
>I decided to drop all the tables, which I did, before issuing a "drop
>tablespace" again.
>Now, the table space is empty and the drop tablespace command has been
>running for hours. Why would it take so long to drop an empty tablespace and
>do I have a greater problem with my remaining database?
>
>Jim.Secor_at_jacobs.com

My guess is that while the tablespace space is "empty" the data dictionary still has plenty of entries pertaining to the extents in the tablespace. The extents are marked as free rather than for a table or index.

Now, when you drop a tablespace, these entries from the data dictionary must be deleted from the dictionary tables. Couldn't the updating of the data dictionary impact the speed with which an object can be dropped?

Murray.Kaiser_at_NSPower.ns.ca Received on Wed Jan 17 1996 - 12:25:29 CST