Re: How to delete tablespace?

From: Mario <msimic_at_alf.tel.hr>
Date: Wed, 23 Sep 1998 15:27:54 +0200
Message-ID: <6uatcl$p9o@as041.tel.hr>

Dmitry Melekhov wrote in message <3608DA8E.748713A7_at_aspec.ru>...
>I get an error in datafile.
>
>But there is rollback segment in this tablespace (and datafile).
>
>When I try to remove tablespace oracle said that rollback is online :(
>
>Oracle 7.3.3 for SCO under Linux.
>
>Any ideas?
>
>--
>Dmitry Melekhov
>(aka 2:5050/11.23_at_fidonet)
>

Try putting rollback segment offline ( "alter rollback segment rbs1 offline" ).
Then drop it and its tablespace. Dont forget to erase specification of this rollback seg in init.ora file.

IHTH Received on Wed Sep 23 1998 - 08:27:54 CDT