Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with temp tablespace
In <30mfov8jm8947opibehdn45qq5t7j2i2ip_at_4ax.com> Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl> writes:
>On Wed, 8 Oct 2003 18:56:07 +0000 (UTC), Stan Brown <stanb_at_panix.com>
>wrote:
>...
>>First why is it trying to use INDEX2_Ts for temp space, when I have altered
>>the sue in question to use TEMP_TS for that?
>...
>A create index statement will first read the required table data into
>the tablespace which is assigned as the temporary tablespace.
>But then, if all is sorted, the index segment in INDEX2_TS must be
>created. Oracle does this by creating a temporary segment in
>INDEX2_TS, filling it with the index data (if this goes wrong you get
>the error you reported). While Oracle is busy filling the segment you
>can check its existance in DBA_SEGMENTS. After Oracle has succeeded
>in filling the segment with all the data, things are made official and
>the temporary segment is rebaptized into a permanent segment with the
>name specified in your create index statement.
>Hope this clears things up.
Indeed it does!
Thanks.
-- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." -- Benjamin FranklinReceived on Sun Oct 12 2003 - 22:08:56 CDT
![]() |
![]() |