index creation -- what temp space is used

From: Saad Ahmad <sahmad_at_mfa.com>
Date: 1995/09/03
Message-ID: <42b79j$80g_at_homer.alpha.net>#1/1


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

--
**************************************************************

* Saad Ahmad *
* McHugh Freeman & Associates, Inc. *
* Ph: (414) 798-8606 Ext. 457 *
* Fax: (414) 798-8619 *
* E-Mail: sahmad_at_mfa.com *
**************************************************************
Received on Sun Sep 03 1995 - 00:00:00 CEST

Original text of this message