RE: Segment_type = TEMPORARY

Whenever a sort can't fit into the user's sort_area_size it will do the sorting in the temporary tablespace, creating temporary extents. Temporary extents will also exist briefly when a new object is being created or dropped. As a table or index is created the extents are all of type temporary and only become permanent once the entire operation is complete. Similarly when an object is dropped the extents will be changed to type temporary and then cleaned up by SMON.

I'm sure I'll be corrected if I got any of that wrong...

-----Original Message-----
From: Luc Demanche [mailto:ldemanch_at_cetelem.fr] Sent: Wednesday, June 07, 2000 10:48 AM
To: Multiple recipients of list ORACLE-L Subject: Segment_type = TEMPORARY

Hi all,

I found 3 segments in dba_segments table with the segment_type = TEMPORARY. What's the meaning of segment_type = TEMPORARY. Did oracle create this ?

TIA

-- 
Author: Luc Demanche
  INET: ldemanch_at_cetelem.fr

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).