ORA-01652: Unable to Extend Temp Segment by 16 in Table Space Apps_ts_summary
Last updated on MARCH 08, 2017
Applies to:Oracle E-Business Intelligence - Version 22.214.171.124 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Supply Chain Intelligence - Version 126.96.36.199 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms