Running the Initial Build of Opportunity and Leads Bins Concurrent Request Receives ORA-12801, ORA-01652
(Doc ID 302059.1)
Last updated on DECEMBER 19, 2022
Applies to:Oracle Sales Online - Version 220.127.116.11 to 18.104.22.168 [Release 11.5.10]
Information in this document applies to any platform.
You are running the Initial Build of Opportunity and Leads Bins concurrent request and the process is ending in error:
Creating materialized view ASF_ROLLUP_MGR_MV
PL/SQL procedure successfully completed.
Inserting into ASF_SC_BIN_MV
and scd.decision_date = asp.period_Day
ERROR at line 68:
ORA-12801: error signaled in parallel query server P003
ORA-01652: unable to extend temp segment by 1280 in tablespace OSMD
Responsibility: Oracle Sales Administrator
Navigate: Concurrent Requests, Run, single request, Initial Build of Opportunity and Leads Bins
Parameters: No of processes (tried several options)
Extent size S, M L (have tried all 3)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!