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

Each user has a temporary tablespace which is used by oracle for processing queries by that user, regardless of the tablespace the query actaully applies to. This is why the TEMP tablespace is being used even though there are no tables in it.

As far as it not being able to extend goes, both the tablespace and the datafile(s) it uses must be able to extend. I believe that the error message you got means that you should add a datafile to your tablespace or allow the one you have to extend.

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
> =======================================
Received on Mon Jan 18 1999 - 16:08:55 CST