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!

Issue after DBMS_REPAIR

smeeOct 1 2013 — edited Oct 2 2013

Hi all,

I have encountered ORA-01578: ORACLE data block corrupted issue with one of tables in my database. Database version is Oracle 10.2.0.4 on Windows Server 2003. After I solved this problem by using document Using DBMS_REPAIR to Repair Data Block Corruption, I found that I'm unable to insert new data into table. Select and update work fine, but insert does not. When I try to insert new record I get ORA-01578 error again.

Do someone have idea how this happened?

Tnx,

Smee

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 30 2013

Added on Oct 1 2013

#general-database-discussions, #issue, #oracle

8 comments

779 views