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!

ORA-00376: file 188 cannot be read at this time

saketbansalMar 17 2010 — edited Mar 17 2010

Dear DBA's,

I recovered a database from older backup,but due to some corruption , I did "offline for drop" for a particular datafile which cud not be completely recovered and opened the database. Now while querying certain tables I get "ORA-00376: file 188 cannot be read at this time".

I figured out that some extents for the table's index partition were allocated into that datafile.

I am trying to rebuild those index partitions but again getting the same error.

Please guide me ,how to rebuild this index without dropping the tablespace and recreating a new one.

Version 9.2.0.5.0. on HP-UX platform

Regards,
Saket Bansal

This post has been answered by Hemant K Chitale on Mar 17 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 14 2010

Added on Mar 17 2010

#general-database-discussions

5 comments

2,483 views