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 12.0.11.1 [Release 12.0]Information in this document applies to any platform.
Checked for relevance July 2013
Symptoms
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...".
Cause
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
Symptoms |
Cause |
Solution |
References |