Re: TEMPORARY SEGMENTS

When you do a CREATE INDEX statement, the index begins life as a temporary segment. It remains a temporary segment while the index is being built. When the index is built, it magically becomes and index segment. If you get an error while the index is being built, the error refers to it as a temp segment (as you have seen).
This is also true for tables.

D S Tharpe wrote:

> Do all tablespaces create their own temporary segments when
> needed? Does anyone have any insight on this? I thought temporary
> segments were only created in the TEMP tablespace. My temporary
> tablespace is set to the TEMP tablespace, but it was not until today
> when I was creating indexes in my INDEX tablespace that I encountered
> the error which caused me to question temp segments. I increased the
> storage parameters on the INDEX tablespace and the index created fine
> then, but I am very confused by temp segments in a NON-TEMP tablespace.
>
>
> max # extents reached in temp segment in tablespace INDEX
> ^^^^^^^^^^^^ ^^^^^^^^^^^^^^^^
>
> Thanks!
>
> D. Tharpe (i5t_at_ornl.gov)
Received on Thu Aug 06 1998 - 07:02:22 CDT