Temp segments are only used when a sort is happening, they are immediately
released as soon as the sort is done. With this in mind, nothing will show
up after the query fails because all is released. You will need to increase
the size of the TEMP tablespace by either adding another datafile or resize
the one you have. You can use the auto extend option in 7.3+ but I would
not recommend that on a TEMP tablespace. If someone tries a join and ends
up with a cartesean product it can blow out a disk (bad news). The best
method is to add another datafile or two and if Oracle needs the space it
will use them and release the space for another user when it is done.
Kenny Gump
OCP 7.3 DBA
Thomas Klinger wrote in message <3691fcf6.9285998_at_a1fw01.mobilkom.at>...
>Help!
>
>I wanted to run a query (normally this one already worked) but my
>server gives back an error.
>
>ORA-1652: unable to extend temp segment by 4982 in tablespace TEMP
>
>This I understand but there are NO tables in our TEMPspace currently
>(looked with 'select * from all_tables where tablespace_name='TEMP';'
>as system).
>
>And there are still over 12000 blocks free! So, also the
>PERCENTAGE_INCREASE 50% is no prob. Diskspace enough, no data in
>TEMP-tablespace, enough space in the tablespace itself, the error
>happens each time.
>
>BTW: The query was already in use!
>
>Why?
>
>
>Kind regards
>
> Thomas Klinger
> Systemspecialist
>=======================================
>t.klinger_at_mobilkom.at
>http://www.mobilkom.at
>=======================================
>
>
>
Received on Thu Jan 07 1999 - 10:18:15 CST
