SYS.DBMS_REDEFINITION Fails With ORA-600 [17183] On Larger Table (Doc ID 1458923.1)

Last updated on JULY 21, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

Alert:log:

Errors in file /sunquest/mgh03pit/admin11g/diag/rdbms/mgh03pit/mgh03pit/trace/mgh03pit_ora_11862032.trc  (incident=78917):
ORA-00600: internal error code, arguments: [17182], [0x110D514D8], [], [], [], [], [], [], [], [], [], []
Incident details in: /sunquest/mgh03pit/admin11g/diag/rdbms/mgh03pit/mgh03pit/incident/incdir_78917/mgh03pit_ora_11862032_i78917.trc

 

Incident file:

ORA-00600: internal error code, arguments: [17183], [0x110D64BF0], [], [], [], [], [], [], [], [], [], []

----- Current SQL Statement for this session (sql_id=3rwa63qw3zupj) -----
                 BEGIN
                 DBMS_REDEFINITION.FINISH_REDEF_TABLE('PRECISE','STORAGE_ITEMS','STORAGE_ITEMS_INTERIM');
                 END;
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
700000319a1bb88        82  package body SYS.DBMS_REDEFINITION
700000319a1bb88      1524  package body SYS.DBMS_REDEFINITION
700000324940050         2  anonymous block

 

Call stack:

skdstdst ksedst1 ksedst dbkedDefDump ksedmp ksfdmp dbgexPhaseII dbgexExplicitEndInc
dbgeEndDDEInvocationImpl dbgeEndDDEInvocatio kgherror kghfrf kkzumco2 kkzuford
kkziford spefcmpa spefmccallstd pextproc peftrusted psdexsp rpiswu2 psdextp pefccal
pefcal pevm_FCAL pfrinstr_FCAL pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe
kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real ssthrdmain main
start

 

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