ORA-1652: unable to extend temp segment by 1280 in tablespace TEMP - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: ORA-1652: unable to extend temp segment by 1280 in tablespace TEMP

  1. #11
    Join Date
    Jun 2001
    if my other tablespaces are all locally managed, I also have to increased the datafile sizes, there is no other way to free up my tablespaces?

  2. #12
    Join Date
    Jun 2000
    Madrid, Spain
    well if they are not full you dont have to increase the datafile size, LMT reuses the spaces effiently (not saying 100%) because with LMT you get 0% fragmentation

  3. #13
    Join Date
    Sep 2001
    Fort Smith
    if you are using a join in your sql and the column in the where clause is not having an indx on it and/ or its position is in a composite index is not allowing the usage of index the sort will be done in the temp tablespace. so depending on the cardinality of the column adding a index to this column will greatly improve the queries performance. if that does not help
    - coalescing the temp tablespace.
    - increasing the sort_area_size parameter.
    - increasing the temp tablespace.


Posting Permissions

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

Click Here to Expand Forum to Full Width