Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Lost datafile - help!!
> 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