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!

dropping a datafile

cobragurlJun 15 2011 — edited Jun 15 2011
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?
This post has been answered by CKPT on Jun 15 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 13 2011
Added on Jun 15 2011
21 comments
3,858 views