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!

ORA-06152: unable to extend temp segment by 128 in tablespace TEMP2

Discussion in 'Oracle Apps Technical' started by jagadekara, Oct 29, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi Friends,

    I am executing one query in sql developer. It is giving the following error.

    ORA-06152: unable to extend temp segment by 128 in tablespace TEMP2

    So how can I resolve this?
     
  2. rajenb

    rajenb Forum Expert

    Messages:
    361
    Likes Received:
    114
    Trophy Points:
    655
    Location:
    Mauritius
    Hi Jagadekara,

    You need to get hold of your DBA/Apps.DBA to sort out this issue by increasing the size of TEMP2 tablespace - either by adding extra datafile or re-sizing the original file.

    Temporary tablespace is used internally by Oracle essentially for joins, sorts etc... and even for certain operations like 'create table A as select * from B' where huge number of rows are involved. But for your case, it looks more like a big query with large number of tables, joins, group by, order by ... I know it's not always easy but try to see from your side if you can change your query also.
     
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Thanks Rajen,

    When I checked the temp space out out 1024 mb 1021 mb free space is there.

    Later I modified my query. Now the problem is solved.