Re: Direct path load failure

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