Concurrent Progrm: ORA-01652: unable to extend temp segment by 16 in tablespace TEMP

  1. RG Hegde

    RG Hegde Forum Advisor

    Messages:
    185
    Likes Received:
    35
    Trophy Points:
    310
    Location:
    Pune
    Hello

    I have migrated one concurrent program from once instance to another.

    it uses pl/sql procedure and the concurrent program is error out with below error

    Cause: FDPSTP failed due to ORA-01652: unable to extend temp segment by 16 in tablespace TEMP
    ORA-06512: at "APPS.XXCUS_RESOURCE_CST_ANALYSIS", line 135
    ORA-06512: at line 1

    The select statement in the procedure is through the error.

    Any Idea...
     
  2. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    401
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Re: Concurrent Progrm: ORA-01652: unable to extend temp segment by 16 in tablespace T

    I don't suppose you had your DBA do what the error message indicates needs to be done?
     
    RG Hegde likes this.
  3. RG Hegde

    RG Hegde Forum Advisor

    Messages:
    185
    Likes Received:
    35
    Trophy Points:
    310
    Location:
    Pune
    Re: Concurrent Progrm: ORA-01652: unable to extend temp segment by 16 in tablespace T

    Yes ,

    I sent mail to my DBA waiting for their response. Lets see .
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,754
    Likes Received:
    148
    Trophy Points:
    1,805
    Location:
    Redondo Beach, California
    Re: Concurrent Progrm: ORA-01652: unable to extend temp segment by 16 in tablespace T

    Need to increase the size for the tablespace where that table resides. Due to reach of space limit it will be errored out.