Re: dropping a tablespace

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/05/23
Message-ID: <959036956.23805.0.pluto.d4ee154e@news.demon.nl>#1/1

use drop tablespace <tablespace_name> including contents

Hth,

Sybrand Bakker, Oracle DBA

Christian Moenne-loccoz <christian.moenne-leccoz_at_fnac.net> schreef in berichtnieuws 39299DE9.840D3252_at_fnac.net...
> 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
>
Received on Tue May 23 2000 - 00:00:00 CDT