My Oracle Support Banner

GLLEZL: When Running Journal Import, Ends with ORA-01652: unable to extend temp segment in tablespace TEMP (Doc ID 2255874.1)

Last updated on SEPTEMBER 08, 2021

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
ORA-01652
GLLEZL

Symptoms

When importing a very large number of journals the following errors occur:

Error in: gllcje
Function return status: 0
Function Err Message: Opening MAIN1
Function warning number: -1
*****************************************************
sqlcaid: sqlabc: 0 sqlcode: -1652 sqlerrml: 67
sqlerrmc:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

sqlerrp: sqlerrd: 0 0 0 5651 0 538976288
sqlwarn: sqltext:
*****************************************************
SHRD0044: Process logging off database and exiting ...

Changes

 Importing very large number of journals form an external source.

Cause

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
Symptoms
Changes
Cause
Solution
References


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