Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Removing completely datafile.....

736332Feb 7 2011 — edited Feb 7 2011
I'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.......
This post has been answered by Pierre Forstmann on Feb 7 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 7 2011
Added on Feb 7 2011
5 comments
426 views