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

From: <satar_at_my-dejanews.com>
Date: Fri, 08 Jan 1999 22:08:33 GMT
Message-ID: <775vku$svd$1@nnrp1.dejanews.com>

If you don't get a response (I'm two days behind reading this newsgroup) from anyone else, e-mail me and I'll explain what is going on and how to correct the problem.

Good Luck,
Satar
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

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 Fri Jan 08 1999 - 16:08:33 CST