My Oracle Support Banner

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 [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:

  1. Run the script s8628004m_mv_size_profile.sql, which creates materialized view MV_SIZE_PROFILE.
  2. 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.