My Oracle Support Banner

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 OCTOBER 04, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.