Re: Direct path load failure

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_at_gmail.com> 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_at_gmail.com> 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
>>
>

--
http://www.freelists.org/webpage/oracle-l