Datafile in RECOVER online_status
From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Sat, 25 Jul 2015 13:46:41 -0300
Message-ID: <CAJdDhaNcAW3PJ5pwrEiK6uaSRLrYXLt07SZuZVxK-fupbx7wdQ_at_mail.gmail.com>
Hello,
Date: Sat, 25 Jul 2015 13:46:41 -0300
Message-ID: <CAJdDhaNcAW3PJ5pwrEiK6uaSRLrYXLt07SZuZVxK-fupbx7wdQ_at_mail.gmail.com>
Hello,
I have a datafile that is in this situation:
SQL> select FILE_ID, STATUS, ONLINE_STATUS from dba_data_files where online_status = 'RECOVER';
FILE_ID STATUS ONLINE_STATUS
---------- --------- -------------
14 AVAILABLE RECOVER
1.) Can I do it ? Is there any impact ?
alter tablespace TBS drop datafile 14;
or
2.) Must I do it:
alter database datafile 14 offline
and them via O/S command : delete the file
Regards
Eriovaldo
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Jul 25 2015 - 18:46:41 CEST