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!

drop offline datafile

2723794Jan 31 2011 — edited Feb 1 2011

Hi All,

someone has making some alteration with datafile which make it corrupt and lastly they put it offline .I am unable to make it online, I am getting (ORA-01157,ORa-01110) error.

I have 10g database in Noarchive mode and also I dont have any backup.

In this situation I perfer to drop this datafile from this tablespace.

please suggest me the proper steps to deal with this situation.

Thanks...

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 1 2011

Added on Jan 31 2011

#general-database-discussions

20 comments

3,616 views