ORA-8103 and ORA-12801 On Insert Operation Within a Select (Doc ID 428694.1)

Last updated on DECEMBER 21, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 - Release: 10.2 to 10.2
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4
***Checked for relevance on 21-Dec-2011***

Symptoms

The  query  involving select statement within an Insert  fails with ORA-8103 .
Tables reside on tablespace which has segment space management  set to auto.
Error occurs only when parallelism is used and Bitmap index are present in the table.

 

 

 
.

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