ORA-08103 During Selects On EHCC Tables after Data has been Loaded (Doc ID 1507511.1)

Last updated on NOVEMBER 22, 2012

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Error ora-8103 is reported, For example:

SQL> select count(*) from ehcc_table where c1 BETWEEN TRUNC(TO_DATE('10/09/2012 00:00:00','MM/DD/YYYY HH24:MI:SS')) AND TRUNC(TO_DATE('10/11/2012 00:00:00','MM/DD/YYYY HH24:MI:SS'));

*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P120, instance
db03.oracle.com:TST3 (3)
ORA-08103: object no longer exists

after data has been loaded into Hybrid columnar Compression (ehcc)  tables using parallel dml.

Analysis on the redo dumps shows that no redo was generated for the affected data blocks, so these blocks were not updated and left with the old image.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms