Re: Datafile of tablespace with rollback segment lost!

There are at least 2 hidden parameters in INIT.ORA pertaining to rollback segments. Better speak with Oracle support and get some help using one of them.

Michael

Haithem Abdelkefi <haithem_at_vigie.qc.ca> wrote:

>Hi all,
 

> I have accidentally deleted a datafile of a tablespace wish contains
>only
>one rollback segment.
>I try to drop the tablespace with the following commands:
> startup mount
> alter tablespace datafile 'datafile_name' offline drop;
> alter tablespace open;
 

>all this fine, when the database was opened I try to drop the tablespace
>with the command :
> drop tablespace 'tablespace_name' including contents;
 

>and I have the error message :
>ORA-01548: active rollback segment 'RB_DATA' found,
> terminate dropping tablespace
 

>It's nor online or offline.
>I can't drop this rollback segment, his status in 'needs recovery' !!
 

>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-2743
Received on Sat Jan 06 1996 - 00:00:00 CET