Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

ORA-08176 will be generated if a transaction encounters data changed by an operation that does not generate rollback data : create index, direct load or discrete transaction. If this exception is encountered, retry the operation that received the exception.

I'm getting lots of (ORA-08176: consistent read failure; rollback data not available) in parallel requests, while loading LOBs through a dblink. I cannot show requests 'cause it's production database. Just interesting about if there is any way to workaround this problem.

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.