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!

HELP!!! I deleted a .dbf file using OS command

NonudayFeb 3 2012 — edited Apr 30 2012

Hi Experts,

I have accidently deleted a datafile, that is my index tablespace(.dbf) using OS command(AIX).

After that I was not able to open my database since the datafile is missing and I was not able to drop the datafile when the database in not open.

I dont any have recover option in my database to rrecover the datafile.

Can anyone pls tel me how can I delete the datafile when my database is not open.

Thanks in advance.

nonuday

Edited by: Nonuday on Apr 29, 2012 10:51 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 2 2012

Added on Feb 3 2012

#database, #general-database-discussions

23 comments

3,087 views