Removing completely datafile.....
736332Feb 7 2011 — edited Feb 7 2011I've added to tablespace another datafile, but it was mistake and i wanted to remove.
So i run the syntax ALTER TABLESPACE <tablespace> DROP DATAFILE 'datafile'
When i finished i noticed that datafile is located in folder "oradata" but in dba_data_files i don't see this datafile is belonged to tablespace.(there is no more this datafile)
I tried to delete manually from the folder, but (of course) it would not delete. It shows me that file is busy.
I know that if alter my database to mount state i can delete this file,but if there is another way to delete this file from folder without stopping database.......