'temp' tablespace out of space?????
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: 'temp' tablespace out of space?????

  1. #1
    Join Date
    Jul 2001
    Posts
    1

    Question

    I have several user queries that are got the the following error message:

    ORA-1652: unable to extend temp segment by 256 in tablespace xxx

    However in viewing and recording the tablespace's usage, I NEVER see it even getting close to be 100% used. The tablespace spans several datafiles and is 5.4 GB in total size.

    Is the 'temp' tablespace limited to single file allocations? Any other ideas???

    Thanks!!!

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    How long the database is up and running ? There may be fragmentation causing the transaction fail to get 256 kb chunk.

    Temp tablespace is not limited to single file allocation.

    I don't think its possible to flush temp tablespace on the fly other than bouncing database which release previously used segments. Have a look at previous threads on TEMP tablespaces maintenance.

    http://www.dbasupport.com/forums/sho...?threadid=7722
    http://www.dbasupport.com/forums/sho...?threadid=6771
    http://www.dbasupport.com/forums/sho...?threadid=5600


    Reddy,Sam

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Time out. I don't think he's talking about the TEMP tablespace.

    ORA-1652: unable to extend temp segment by 256 in tablespace xxx

    indicates there is not enough space in XXX, not TEMP.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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