BEN100A.SQR Performance issue, ORA-01652: Unable to Extend Temp Segment

(Doc ID 655121.1)

Last updated on SEPTEMBER 28, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms