GLLEZL: When Running Journal Import Ends with ORA-01652: unable to extend temp segment in tablespace TEMP

(Doc ID 2255874.1)

Last updated on APRIL 30, 2017

Applies to:

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


 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
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 ...


 Importing very large number of journals form an external source.


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