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

Home -> Community -> Usenet -> c.d.o.server -> Re: Lost datafile - help!!

Re: Lost datafile - help!!

From: rob <rob_at_dsdelft.nl>
Date: Fri, 22 Jun 2001 09:53:25 +0200
Message-ID: <9guthk$5cu$1@news.tudelft.nl>

> SVRMGR> alter database datafile '/u02/oradata/db1/rbs01.dbf' offline drop;
> Statement processed.
> SVRMGR> alter database open;
> Statement processed.
> SVRMGR> alter tablespace rbs offline;
> alter tablespace rbs offline
> *
> ORA-01191: file 2 is already offline - cannot do a normal offline
> ORA-01110: data file 2: '/u02/oradata/db1/rbs01.dbf'
> SVRMGR> drop tablespace rbs;
> drop tablespace rbs
> *
> ORA-01549: tablespace not empty, use INCLUDING CONTENTS option
> SVRMGR> drop tablespace rbs including contents;
> drop tablespace rbs including contents
> *
> ORA-01548: active rollback segment 'R01' found, terminate dropping
> tablespace
> SVRMGR>

Try this
Edit your init.ora file. Comment out the rollback_segments. Restart the database.
drop the tablespace.

Rob. Received on Fri Jun 22 2001 - 02:53:25 CDT

Original text of this message

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