Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to delete tablespace?

Re: How to delete tablespace?

From: Dmitry Melekhov <dm_at_aspec.ru>
Date: Wed, 23 Sep 1998 14:36:45 +0400
Message-ID: <6uafb0$1n9$1@hq.mark-itt.ru>

Peter Rak пишет в сообщении <3608A007.F801F33_at_vsz.sk> ...
>Hi,
>alter rollback segment ... offline;

I can't do it :(
because datafile is corrupted.
>delete rollback segment name from INIT.ORA
And I don't have this file ;)
>> 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?
Received on Wed Sep 23 1998 - 05:36:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US