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

Home -> Community -> Mailing Lists -> Oracle-L -> Datafile of tablespace with rollback segment lost!

Datafile of tablespace with rollback segment lost!

From: Haithem Abdelkefi <haithem_at_VIGIE.QC.CA>
Date: Sun, 7 Jan 1996 18:32:37 -0500
Message-Id: <9601072342.AA32532@alice.jcc.com>


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 is 'needs recovery' !!

I heard that I need to restart the database after adding a variable to the INIT.ORA file for the rollback segment...

Has anybody know what I must add at the init.ora file?

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 Sun Jan 07 1996 - 18:42:31 CST

Original text of this message

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