ORA-01652: Unable to Extend Temp Segment by 16 in Table Space Apps_ts_summary (Doc ID 433481.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle E-Business Intelligence - Version 11.5.10.0 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Supply Chain Intelligence - Version 11.5.10.0 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
E-Business Intelligence - Version: 11.5.10 to 12.0.
***Checked for relevance on 10-Dec-2013***


Symptoms

On 11.5.10 in Production:
When attempting to run the Initial load for the Supply Chain dashboard,
the following error occurs:

ERROR
ORA-12801: error signaled in parallel query server XXXX, instance XXXX
ORA-01652: unable to extend TEMP segment by 16 in tablespace APPS_TS_SUMMARY
ORA-06512: at "APPS.BIS_MV_REFRESH", line 207
ORA-06512: at "APPS.BIS_MV_R

This error can occur for BISX and BISD tablespaces as well as TEMP tablespace.
Depending on how much data is being snapshot, the tablespace sizes can go into 100G.

Cause

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