Unable to Drop - RBS

In the following dialogue, the user had deleted the Data File at the OS. I then suggested OFFLINE-DROPping the File with the DB *not OPEN*. However, it seems that there is an RBS in the file.
What is the Oracle Error when attempting to Drop the RBS ?

What is to be done is to put the following in the init.ora :

1. remove the RBS from the init.ora
2. Shutdown and Restart the instance. (if in V7, you do not need to shutdown and statup. You can do ALTER ROLLBACK SEGMENT RB_DATA OFFLINE while in SQLPLUS/SQLDBA).

This will ignore the RBS when *OPENing* the DB. You can then DROP the Rollback Segment when the DB is OPEN. Then DROP the Tablespace.

Sender: "ORACLE database mailing list." <ORACLE-L_at_CCVM.SUNYSB.EDU>
> From: Haithem Abdelkefi <haithem_at_VIGIE.QC.CA>
> Subject: Re: I have deleted a datafile.
> X-To: "ORACLE database mailing list." <ORACLE-L_at_ccvm.sunysb.edu>
> X-cc: hemant_at_SHAKTI.NCST.ERNET.IN
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_CCVM.SUNYSB.EDU>
> Status: RO
>
> What about when the tablaspace has a rollback segment ??
> I try DROP TABLESPACE NAME INCLUDING CONTENTS
> but i have the
> ORA-01548: active rollback segment 'RB_DATA' found, terminate dropping
 tablespae
> error...
>
> the rollback segment 'RB_DATA' doesn't exist,
> i try the fllowin commands but without succes!!!
> drop rollback segment rb_data;
>
> any help are very appreciated.
> haithem
>
> At 09:56 95-11-07 +0530, you wrote:
> >Use the following commands in SQLDBA
> >
> >STARTUP NOMOUNT
> >ALTER DATABASE MOUNT
> >ALTER DATABASE DATAFILE '<specify the file name and path>' OFFLINE DROP
> >ALTER DATABASE OPEN
> >
> >Once the Database is OPEN,
> >DROP TABLESPACE TEMP (which had the file).
> >
> >Hemant K Chitale
> >BTW : Setting a Tablespace Storage Parameter wrongly cannot result in
> >an error of the type "not enought space for log file".
> >
> >You might try the above for both the NEW and the TEMP Tablespace.
> >I hope you had NO Objects in TEMP !
> >
> >
> >> From: Zhang Lei <zhangl_at_PRLSUN1.IA.AC.CN>
> >> Subject: I have deleted a datafile.
> >> X-To: ORACLE-L_at_ccvm.sunysb.edu
> >> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_CCVM.SUNYSB.EDU>
> >> Status: RO
> >>
> >> Hi, friends,
> >> What a fool I am! I set a tablespace's storage arguments wrongly. That is
 to
> >> say, I set the 'initial' parameter to 100M. Then when I shutdown and
> restart,
> >> I was told that there was not enough space for log file, and the instance
> > didn't
> >> startup. Then I tried to delete some files from the disk. I deleted a temp
> > data
> >> file which had served as temp file for a tablespace. Then tradgedy
 happened!
> >> I cannot get the database started any more! And I cannot get the deleted
 file
> >> restored. What shall I do?
> >> -desperate Lei Zhang
> >>
> >
Received on Tue Jan 09 1996 - 06:21:34 CST