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: and later   [Release: 10.2 and later ]


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


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