KUP-00600: [KUDMRS:GTL] On External Table With Large Amount Of Data (Doc ID 2304193.1)

Last updated on SEPTEMBER 05, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Getting KUP-00600 [kudmrs:GTL] while accessing a large external table during a create table as select execution in parallel mode.

The complete error message looks like:

ORA-12801: error signaled in parallel query server
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
KUP-00600: internal error, arguments [kudmrs:GTL] [17013] [17013] [] []


The current SQL reported in the incident trace file is:

----- Current SQL Statement for this session (sql_id=27kfwk7v044y2) -----
create table SRC_CUST_ADDL_NORMAL
NOLOGGING
COMPRESS FOR QUERY HIGH
parallel (degree 32)
as select /*+ parallel(CUST_ADDL_DETAILS 32) */ * from CUST_ADDL_DETAILS

and the generated plan table confirms the existence of external table:

 

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