ORA-08103 During Selects On EHCC Tables after Data has been Loaded
Last updated on NOVEMBER 22, 2012
Applies to:Oracle Server - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 11.2]
Information in this document applies to any platform.
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms