My Oracle Support Banner

BEN100A.SQR Performance issue, ORA-01652: Unable to Extend Temp Segment (Doc ID 655121.1)

Last updated on FEBRUARY 03, 2019

Applies to:

PeopleSoft Enterprise HRMS Human Resources - Version 8.8 SP1 to 9.2 [Release 8.8 to 9]
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 201043543


Symptoms

ORA10:Ben100a.sqr is failing with SQL Error = ORA-01652: unable to extend temp segment
...1X-Implied-Term-Dep (01:57:34_PM)
/ds1/home/h890g20p/sqr/ben100a.sqr: ENROLLMENT REPORTING SNAPSHOT - SQL Statement =
SQL Status = 1652, SQL Error = ORA-01652: unable to extend temp segment by 16 in tablespace PSTEMP

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

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