Re: Datafile of tablespace with rollback segment lost!

Haithem Abdelkefi (haithem_at_vigie.qc.ca) wrote:
: Hi all,
:
:
: 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

Have you removed the rollback segment from the init<ORACLE_SID>.ora file ?? If not, do it. That may be the cause. The init.ora parameter you should look for is - rollback_segments -.

-- 

   /---------------------Get high..... SNOWBOARD---------------------------\
  /                                                                         \
 (   Full name: Morten Kristiansen        Email     : d93krist_at_hfk.mil.no    )