Oracle drops temporary segments once the statement that needed them
completes.
Leonardo Camargo wrote:
>
> 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 - 15:00:20 CST
