一个文件已不再需要, 但DROP不了.
SQL> ALTER DATABASE DATAFILE 23 ONLINE;
ALTER DATABASE DATAFILE 23 ONLINE
*
ERROR at line 1:
ORA-01113: file 23 needs media recovery
ORA-01110: data file 23: '/u02/oracle/oradata/ORCL/tempx02.dbf'
SQL> ALTER DATABASE DATAFILE 23 OFFLINE FOR DROP;
Database altered.
SQL>select * from V$datafile
-->Datafile 23 依然存在,STATUS='RECOVER'
已恢复不了,因Archive Log已不可得.
我该如何做,才能Drop this file. This file belongs toRBS tablespace.
oh, help
you can not drop datafile with "alter database datafile .... offline drop", it still remain in
the data dictionary until you drop the tablespace where the datafile sit in.
Now do like this:
(1)create undo tablespace newundo
datafile '.....' size 50m
(2)alter system set undo_tablespace=newundo;
(3)Before the following command, make sure no active transcation using rollback
segments in the old undo tablespace:
drop tablespace oldundo including contents and datafiles