Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TEMPORARY segment type in temp tablespace

Ora_83Jun 25 2011 — edited Jun 26 2011

Hi

Oracle 9i. I have noticed the following segment in temporary tablespace. Is there way to get rid of this? or Should I get rid of this ?
Any idea how to interpret this ?

Thanks in advance

SQL>  select owner,SEGMENT_TYPE from dba_segments where tablespace_name='TEMP';

OWNER                          SEGMENT_TYPE       
------------------------------ ------------------ 
SYS                            TEMPORARY

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 24 2011

Added on Jun 25 2011

#general-database-discussions

14 comments

3,354 views