Re: How to delete tablespace?

Hi,
alter rollback segment ... offline;
delete rollback segment name from INIT.ORA restart database
drop rollback segment
drop tablespace

Peter Rak
VSZ Kosice
Slovak Republic

Dmitry Melekhov wrote:

> 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)
Received on Wed Sep 23 1998 - 02:15:19 CDT