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 FEBRUARY 02, 2022
Applies to:Oracle Retail Merchandising System - Version 12.0.10 to 18.104.22.168 [Release 12.0]
Information in this document applies to any platform.
When attempting to apply <Patch 8628004> (which is dropping an existing Materialized View and creating a new one), the following error occurs:
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