A SQL*Loader Job Is Failing With An ORA-00600 [Qesmmcsettempseg] Preceded By An ORA-01652 In The Alert Log. (Doc ID 950177.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later   [Release: 10.2 and later ]

Symptoms

You could be running a SQL*Loader job that's failing with the below errors:

SQL*Loader-961: Error calling once/load finishing for table <schema_name.table_name>
ORA-00600: internal error code, arguments: [qesmmCSetTempSeg], [3], [], [], [], [], [], []
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue
 
And in the alert log, you see that this ORA-00600 is preceded by an ORA-01652 error:

ORA-1652: unable to extend temp segment by 1280 in tablespace TEMP

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