My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

Applies to:

Oracle E-Business Intelligence - Version to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Supply Chain Intelligence - Version 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***


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

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.




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.