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
    Posts
    243
    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
    Location
    Madrid, Spain
    Posts
    7,447
    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
    Location
    Fort Smith
    Posts
    184
    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
    try
    - coalescing the temp tablespace.
    - increasing the sort_area_size parameter.
    - increasing the temp tablespace.



    sonofsita
    http://www.ordba.net

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