Unable To Extend Temp Segment By XX In Tablespace MSCX During Collections
(Doc ID 761989.1)
Last updated on SEPTEMBER 11, 2019
Applies to:Oracle Advanced Supply Chain Planning - Version 22.214.171.124 and later
Information in this document applies to any platform.
*** Checked for relevance on 11-JUL-2013 ***
On 126.96.36.199 in Production:
When attempting to running the ODS load, the client is frequently running out of space
CREATE INDEX ITEM_CATEGORIES_N4_XXX ON
PARALLEL TABLESPACE MSCX STORAGE( INITIAL 40960 NEXT 43540135936 PCTINCREASE 50) PCTFREE 10
INITRANS 11 MAXTRANS 255
ORA-12801: error signaled in parallel query server P000
ORA-01652: unable to extend temp segment by 5314960 in tablespace MSCX
The issue can be reproduced at will with the following steps:
1. Run Collections
The issue has the following business impact:
Due to this issue, users have to wait until the table space has been expanded and then collections
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