1

Topic: datafile status recover

Hello!
Request

SELECT NAME;
FILE#;
STATUS;
CHECKPOINT_CHANGE# "CHECKPOINT"
FROM V$DATAFILE;

Shows that at datafile "STATISTICS_TABLESPACE_25.DBF" status RECOVER.
Command

ALTER DATABASE DATAFILE ' C:\ORACLE\ORADATA\SSDB\STATISTICS_TABLESPACE_25.DBF ' OFFLINE FOR DROP;

Changes nothing.
1) That it is necessary to make, that the file status passed from RECOVER in OFFLINE?
2) And how to make so that it at all was not in list V$DATAFILE?
File STATISTICS_TABLESPACE_25.DBF is already remote from a disk. sad
Thanks!

2

Re: datafile status recover

In offline