Re: Datafile in RECOVER online_status

From: MacGregor, Ian A. <ian_at_slac.stanford.edu>
Date: Sun, 26 Jul 2015 00:56:07 +0000
Message-ID: <370CB38E-D16D-4E9D-9C2B-80E105A4370F_at_slac.stanford.edu>

I think you can ALSO drop an empty data file from tablespace which has multiple datafilee unless that data file is the original datafile of that tablespace which again has multiple data files.

Ian MacGregor
SLAC National Accelerator Laboratory
On Jul 25, 2015, at 10:01 AM, Ls Cheng <exriscer_at_gmail.com<mailto:exriscer_at_gmail.com>> wrote:

hi

you cannot drop a datafile from a tablespace (unless it is the only datafile of course), you must restore a backup and recover it

thanks

On Sat, Jul 25, 2015 at 6:46 PM, Eriovaldo Andrietta <ecandrietta_at_gmail.com<mailto:ecandrietta_at_gmail.com>> wrote: 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 Sun Jul 26 2015 - 02:56:07 CEST