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

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with temp tablespace

Re: Problem with temp tablespace

From: Stan Brown <stanb_at_panix.com>
Date: Mon, 13 Oct 2003 03:08:56 +0000 (UTC)
Message-ID: <bmd508$etk$1@reader2.panix.com>


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 Franklin
Received on Sun Oct 12 2003 - 22:08:56 CDT

Original text of this message

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