Creation of Materialized View is Giving Error Message "ORA-01652: Unable to Extend TEMP Segment" While Applying Patch 8628004
(Doc ID 1107563.1)
Last updated on AUGUST 10, 2020
Applies to:Oracle Retail Merchandising System - Version 12.0.10 to 126.96.36.199 [Release 12.0]
Information in this document applies to any platform.
Checked for relevance July 2013
When attempting to apply <Patch 8628004> (which is dropping an existing Materialized View and creating a new one), the following error occurs:
ORA-12801: error signaled in parallel query server P002
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Steps to Reproduce:
- Run the script s8628004m_mv_size_profile.sql, which creates materialized view MV_SIZE_PROFILE.
- Note that execution of this script produces the error: "Unable to extend temp segment...".
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