Re: index creation -- what temp space is used

Saad Ahmad (sahmad_at_mfa.com) writes:
> When creating indexes, where does the temporary info
> go.
>
> I thought it would use the user's temporary tablespace
> but it looks like it also creates stuff in the tablespace
> that is being worked on for creating index...
> And when it is creating temporary segments what
> initial/next extents does it use

  The initial sorting required for the index takes place in the temporary tablespace (and space is allocated according to the default storage parameters of that tablespace). Then when sorting is commplete, the index is built in its destination tablespace according to the default or explicit storage parameters you give. While the index is under final construction it "appears" as a temporary segment but when all is completed it becomes an index segment.

--
   - Doug Harris
     IS Project Leader, Prices Division,
     Statistics Canada.        ## WHERE ALL_OPINIONS.OWNER = USER ##