Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006

    Unanswered: unable to extend temp segment by 128 in tablespace


    When I am running a big search query in Oracle 9i, I got this exception.

    java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

    May I know the cause for this and if by increasing the TEMP size, will it be a permanent solution.

    Pl. can any expert advice me on this, how can I prevent the database from getting this exception.

    Thanks in advancd

  2. #2
    Join Date
    May 2006
    There are really two types of answers to this one.

    1. Yes you have run out of space in TEMP and increasing the files allocated to TEMP might be your only solution. Be cautious as you might also just be running your query when TEMP has been filled up by another appliation query. If this is the case you might be abe to get away with running your query at another time. If not then just increase TEMP.

    2. You can also look at your application and the query itself and verify it is optimal for the data you are going after. I have seen many TEMP areas get completely filled up just by an unused index.

  3. #3
    Join Date
    Sep 2004
    Try to divide the query to more than one if pissible.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts