1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

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

Discussion in 'Oracle Apps Technical' started by RG Hegde, Feb 25, 2015.

  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:
    402
    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,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    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.