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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Removing offline Datafile

974727Nov 16 2012 — edited Nov 19 2012

Hello,

(Total noob please help)

Regarding Oracle 11g

A co-worker added a datafile to a tablespace, however he didn't like what he had named it, so he placed that datafile offline, and created another.

So now, I have a tablespace named "Data" with three datafiles associated with it:
"Data01.dbf" online,
"Data02.dbf", online
"Data02", offline

I tried logging in to sqlplus sys as sysdba and running.

"Alter tablespace data drop datafile "c:\location\data02";

but that didn't work, gives me the error that the data file must be online in order to drop it.
I tried "Place online" using Oracle enterprise manager but it gives me an error.
ORA-01113: file 32 needs media recovery ORA-01110: data file 32: 'c:\location\DATA02' .

How do I remove the file from the system?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 17 2012

Added on Nov 16 2012

#11g, #general-database-discussions

5 comments

1,478 views