Re: dropping a tablespace

Here's just a wild guess on the problem. After dropping your objects in that tablespace, SMON could have been doing some cleanup work. If SMON was busy with the tablespace, then the tablespace won't be dropped until SMON is done with it. I had this problem recently. Sybrand's suggestion to use the 'INCLUDING CONTENTS' is best.

HTH,
Brian  

Christian Moenne-loccoz wrote:
>
> I have tried to drop a tablespace (1.2 Go) which used to contain only
> index.
>
> I first drop all the index contained in it and then put it offline.
>
> However, it has took 18 hours to drop the table space.
>
> Is it normal ?
>
> C. Moenne-Loccoz
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================