Re: Segment_type = TEMPORARY

Yes, Oracle create temporary segments for sorting purpose, they are owned by sys and should reside in a particular temporary tablespace.

Also, while Oracle creating index, before it's done, the segments that are used in building the index will also marked "temporary" until the index is done and it will change it back to "index". So, don't be surprised if you see segment marked "temporary" in the index tablesapce also.

And if you really never heard of the TEMPORARY segment, I will suggest you to start reading the Oracle concept menu, which is a very great book to get an idea how the database work.

Winnie

Luc Demanche <ldemanch_at_cetelem.fr> on 06/07/2000 07:47:48 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

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).