Temp segment, info problem.

From: Leonardo Camargo <leonardo.camargo_at_eds.com>
Date: 28 Mar 2002 11:06:56 -0800
Message-ID: <2f37b4d5.0203281106.414d5d5d@posting.google.com>

Hi all,

I have the following problem, or i am a crossed-eye.

In my alert log file i have :
Thu Mar 28 14:50:01 2002
ORA-1652: unable to extend temp segment by 32768 in tablespace SYSTEM But when i sum all bytes in dba_free_space for system TS i get :

TABLESPACE_NAME                SUM(BYTES)


------------------------------ ----------

SYSTEM                          635076608

But i dont have a temp segment in system ts: SQL> select distinct segment_type from dba_segments where tablespace_name = 'SYSTEM' ;
SEGMENT_TYPE

CACHE
CLUSTER
INDEX
LOBINDEX
LOBSEGMENT
ROLLBACK or am i doing something too wrong ?

Thanks in advance.

Leo Received on Thu Mar 28 2002 - 13:06:56 CST