Skip to Main Content

Español

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-08176: consistent read failure; rollback data not available

Administracion BBDD IberdrolaFeb 20 2020 — edited Feb 20 2020

I have Oracle Database 12.1.0.2 version and when refreshing a materialized view the following error appears:

BEGIN DBMS_MVIEW.REFRESH(list=>'GENERADOR',method=>'C',atomic_refresh=>FALSE); END;

*

ERROR at line 1:

ORA-12008: error in materialized view or zonemap refresh path

ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3012

ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2424

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

ORA-02063: preceding line from GISP

ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 88

ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 253

ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2405

ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2968

ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3255

ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3287

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 16

ORA-06512: at line 1

Comments
Post Details
Added on Feb 20 2020
1 comment
872 views