Datafile of tablespace with rollback segment lost!
From: Haithem Abdelkefi <haithem_at_vigie.qc.ca>
Date: 1996/01/05
Message-ID: <4cjuns$qlu_at_news.worldlinx.com>#1/1
Date: 1996/01/05
Message-ID: <4cjuns$qlu_at_news.worldlinx.com>#1/1
Hi all;
I have accidentally deleted the datafile of a tablespce with contains only a rollback segment...
I try this commands to drop the tablespace:
STARTUP MOUNT
terminate dropping tablespace
ALTER DATABASE DATAFILE 'NAME_DATAFILE' OFFLINE DROP
ALTER DATABASE OPEN
all this is fine, after opening the database I try to drop the
tablespace : DROP TABLESPACE 'NAME_TABLESPACE' INCLUDING CONTENTS
I have the message
ORA-01548: active rollback segment 'RB_DATA' found,
The rollback segment is nor online or offline, his status is needs recovery !! I can't drop it.
Any help are very appreciated.
Haithem
_______ ___________ __ \ \ / / / / Haithem Abdelkefi \ \ / / / / Vigie Informatique 2000 Inc. \ \ /__________/ / / 6433, chemin St-Francois, \ \ _________/ / St-Laurent, Quebec \ \ \ / H4S 1B6 \ \ \ / \ \ \ / email: haithem_at_vigie.qc.ca \ \ \ / Tel: (514)956-9138 \______\ \_/ Fax: (514)331-2743Received on Fri Jan 05 1996 - 00:00:00 CET