Re: HELP!! URGENT!! Need help on administration !! Oracle 7.3.2

Sounds like your temp tablespace is fragmented.

To fix, connect as system in sqlplus or svrmgr23:

     alter tablespace <insert_temp_tablespace_name_here> coalesce;

Connect as system and run the following in sqlplus to verify:

<-------------cut--------------->

prompt
prompt Check for Segment Fragmentation. Use "Alter tablespace <tablespacename> coalesce" to remedy.

select tablespace_name,

    percent_extents_coalesced "> 50%?",     percent_blocks_coalesced "> 50?"
from dba_free_space_coalesced;

<-------------paste------------->

In article <3691fcf6.9285998_at_a1fw01.mobilkom.at>,   t.klinger_at_mobilkom.at (Thomas Klinger) wrote:
> 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
> =======================================
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Jan 20 1999 - 10:40:26 CST