My Oracle Support Banner

OBIA How to handle 'ORA-01652: unable to extend the temp segment by 128 in tablespace' error messages? (Doc ID 1359238.1)

Last updated on MARCH 08, 2017

Applies to:

Business Intelligence Applications Observer - Version 7.8.2 [AA 1346] and later
Information in this document applies to any platform.
21st May 2013 - Checked for Relevance
27th Oct 2014 - Checked for Relevance


 'Why?' do we get this error message when running a Full Load in BI Apps : -

This is a typical example handled recently on the 'SDE_ORA_PAYROLLFACT' Task :-

java.sql.SQL.Exception: ORA-01652: unable to extend the temp segment by 128 in tablespace XXXYYY
ORA-02063: preceding line from AAZZ


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.