Re: Sanity Check Please: Removing Datafiles after Dropping Tablespace?

Yes, if you're sure Oracle is no longer using them, there should be no problem dropping them. As long as the tablespace is gone, you're good to drop the corresponding datafiles.

-Mark

On Tue, May 25, 2021 at 9:33 AM Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:

> The datafiles are not listed as part of the database because I dropped the
> tablespace already.
>
> So now its just a matter cleaning the datafiles off the OS.
>
> Thanks,
> Chris
>
>
> On Tue, May 25, 2021 at 9:30 AM Guenadi Jilevski <gjilevski_at_gmail.com>
> wrote:
>
>> Hi,
>>
>> Could you please look at :
>> https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:515222144417%20
>>
>> ALTER DATABASE DATAFILE OFFLINE DROP..
>>
>> Best Regards,
>>
>> Guenadi Jilevski
>>
>> On Tue, May 25, 2021 at 2:21 PM Chris Taylor <
>> christopherdtaylor1994_at_gmail.com> wrote:
>>
>>> Env :12.1.0.2 x86-64 Linux NON-RAC,NON-ASM
>>>
>>> As haste makes waste (or leaves waste as the case may be), I dropped a
>>> tablespace as part of a scheduled maintenance. However, I neglected the
>>> "INCLUDING CONTENTS AND DATAFILES" portion of the drop command.
>>>
>>> So now I have a lot of datafiles left on the OS.
>>>
>>> I've confirmed that fuser doesn't show any PIDs touching the datafiles.
>>>
>>> I *think *I can drop the datafiles straight from the OS now on both the
>>> primary and standby, but need a sanity check here if anyone knows something
>>> different? I'm being careful here in case I've forgotten something.
>>>
>>> Thanks,
>>> Chris
>>>
>>>
>>>

--
http://www.freelists.org/webpage/oracle-l