Re: dropping a tablespace

The command was "DROP TABLESPACE xxxx INCLUDING CONTENTS CASCADE CONSTRAINTS". Thank for your help.

Brian Peasland a écrit :

> 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