Re: ORA-08176: consistent read failure; rollback data not available

Are you using flashback query?

Direct loads can cause a transaction to fail on an object that has been loaded with direct loads.

The error is easy to duplicate.

Session 1:

create table TEST_8176
as
select *
from dba_objects
/

grant select,flashback on TEST_8176 to scott;

Session 2: ( scott/tiger)
  1 select count(*)
  2 from jkstill.TEST_8176
  3* as of timestamp(systimestamp - interval '1' second ) 22:04:01 poirot.jks.com - scott_at_ts02 SQL> / from jkstill.TEST_8176

             *
ERROR at line 2:
ORA-08176: consistent read failure; rollback data not available    

22:04:02 poirot.jks.com - scott_at_ts02 SQL>

This is different from ORA-1555 in that the undo data never existed in the first place.

On Thu, 25 Nov 2004 12:57:04 +0530, Vaidya, ShreepadX M <shreepadx.m.vaidya_at_intel.com> wrote:
> Hi,
>
> We implemented UNDO management on our servers and started getting these
> errors for few of our programs:=20
>
> ORA-08176: consistent read failure; rollback data not available=20
>
> Per Oracle9i Database Error Messages reference:
> Cause: Encountered data changed by an operation that does not generate
> rollback data: create index, direct load or discrete transaction.=20
>
> Action: In read/write transactions, retry the intended operation.
> Read-only transactions must be restarted.
>
> We did not encounter these errors when we were using the old rollback
> segments and we have not changed any code on our server.=20
>
> Our environment is Oracle 9.2.0.5.0 DB on Windows 2000 AS.
>
> Any inputs/suggestions would be great.
>
> Thanks and regads
> Shreepad=20
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l