It may be bug 27658166, there are one-offs for several version, check with
support if they have one for your 19.5, or upgrade to 19.11.
rgds
On Tue, May 11, 2021 at 10:44 AM Lok P <loknath.73@xxxxxxxxx> wrote:
Yes there are ~20+ bitmap indexes( on individual columns ) and one primary
key index present in this Range-HASH composite partition table. all the
indexes are local. It's exadata X5. The oracle version is 19.5.0.0.0. I see
we have historical partitions compressed using the "ARCHIVE HIGH" option.
Regards
Lok
On Tue, May 11, 2021 at 1:40 PM Ghassan Salem <salem.ghassan@xxxxxxxxx>
wrote:
Lok,
what version? Exa or not? with bitmap index on the table? hcc?
rgds
On Tue, May 11, 2021 at 9:42 AM Lok P <loknath.73@xxxxxxxxx> wrote:
We have an INSERT statement inside a procedure which looks like below.
It keeps on failing with Ora-0600 even if we try to rerun multiple times.
And we got below doc which is matching with the symptom and its stating its
because of a bad rowid issue and APPEND hint is the one triggering the
error so need to get rid of the APPEND hint. Also Oracle support agrees on
the same. But APPEND was there because making the data load fast as it
dumps 100's of millions of rows at one shot into the target table. So
removing append seems to create other performance related problems for us.
Also that INSERT query is part of a complex procedure which does multiple
other inserts based on run time variables till it reaches that point. So I
wanted to understand if there was any other way around to get rid of this
error and fix this issue.
insert /*+append parallel(4)*/ into tabl1(....) select
/*+parallel(4)/...;
ORA-00600: internal error code, arguments: [kdiblsorget:rowidIllegal],
[4008], [4008], [], [], [], [], [], [], [], [], []
INSERT with APPEND Hint = ORA-600[kdiblsorget:rowidIllegal] (Doc ID
2396979.1)
Regards
Lok
