RE: Direct path load failure

Oracle Support are the best people to comment on what the circumstances of the bug are and whether there is any other workaround. You need to put pressure on them to provide a patch fix for the bug.

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

From: Lok P<mailto:loknath.73_at_gmail.com> Sent: 11 May 2021 08:42
To: Oracle L<mailto:oracle-l_at_freelists.org> Subject: Direct path load failure

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