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

From: Thomas Klinger <t.klinger_at_mobilkom.at>
Date: Thu, 07 Jan 1999 12:59:09 GMT
Message-ID: <3691fcf6.9285998@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 - 06:59:09 CST