dropping a datafile
Went to add a datafile to a tablespace using create like in oem.
I forgot the give it a name so it named it .dbf and also put it in the wrong place.
I took it offline immediately and tried to rename it using OEM. I got an error about needing media recovery.
I issued the following command to recover the datafile which changed the online_status from "recover" to "offline" in the dba_data_files view.
SQL> recover datafile '/u03/oradata/instance_name/.dbf'
Is there anything special I need to do to drop this datafile? It is currently offline and appears to be empty?