1652 - ORA-01652: unable to extend temp segment by 128 in tablespace PSTEMP
Hi, Experts
We present the next issue:
Environment:
=============
TEST
IBM AIX 7.1 on POWER Systems (64-bit)
PeopleTools 8.51.16
Application Version: FSCM 9.1
Oracle Database: Release 11.2.0.3.0
Webserver: Oracle WebLogic Server 11gR1 (10.3.6)
Oracle Tuxedo 10.3.0.0, Patch Rp057
ERROR:
File:
e:\pt85116b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1617
Error Position: 12 Return: 1652 - ORA-01652: unable to extend temp segment by
128 in tablespace PSTEMP Failed SQL stmt:INSERT INTO PS_COMBO_DATA_TBL (SETID,
PROCESS_GROUP, COMBINATION, ACCOUNT, ALTACCT, DEPTID, OPERATING_UNIT, PRODUCT,
FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIAT E_INTRA1,
AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, PROJECT_ID, BOOK_CODE,
CURRENCY_C D, STATISTICS_CODE, VALID_CODE, EFFDT_FROM, EFFDT_OPEN, EFFDT_TO)
SELECT DISTINCT A.SETID, A.PROCES S_GROUP, A.COMBINATION, A.RANGE_FROM_30, ' ',
B.RANGE_FROM_30, D.RANGE_FROM_30, C.RANGE_FROM_30, ' ' , ' ', ' ',
E.RANGE_FROM_30, ' ', ' ', ' ', F.RANGE_FROM_30, ' ', ' ', ' ', ' ', ' ', ' ',
'V', CR.E FFDT_FROM, CR.EFFDT_OPEN, CR.EFFDT_TO
0