Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Sort Space

Re: Sort Space

From: <exu_at_nnng.com>
Date: Fri, 5 Jan 2001 08:36:05 -0600
Message-Id: <10732.125830@fatcity.com> 





When you create the table, indexes belong to this table were also created.
During index creation,  server process sort the index calues
before building  the index tree.  Oracle server using a temporary segment in the
 INDEX tablespaces to build and sort a final
index. The segment type will be changed to index once the index has been built
completely.



Eveleen
Received on Fri Jan 05 2001 - 08:36:05 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US