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 AUGUST 10, 2020

Applies to:

Oracle Retail Merchandising System - Version 12.0.10 to [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:

  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.