Re: TEMPORARY SEGMENTS

Just to clarify,

>Temporary segments will go to the user's temporary tablespace,
>again given the needed quota allowance.

No.

Temporary segments are written by SYS in the tablespace that is designated as a user's temporary tablespace, so no quota allowance is necessary. In fact, the user should have 0 quota on the temp tablespace.

I've seen the original error on indexes being created whose storage parameters exceed the maxextents (maxextents=15) default storage parameters of tablespaces.

Regards,
Craig M. Wall

Saar wrote in message <35C8CB97.7506BEC_at_us.oracle.com>...
>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.
>>
>>
>
>Each user has a temporary tablespace & default tablespace.Given space
>quota privileges a user will
>create tables/indexes in the default tablespace if no
>tablespace was specified on the create command.
>Temporary segments will go to the user's temporary tablespace,
>again given the needed quota allowance.
>
>so to make sure temp segments get created only in temp tablespace
>issue: alter user x temporary tablespace temp; to all relevant users.
>
>> max # extents reached in temp segment in tablespace INDEX
>> ^^^^^^^^^^^^ ^^^^^^^^^^^^^^^^
>>
>> Thanks!
>>
>> D. Tharpe (i5t_at_ornl.gov)
>
>
>
>--
> __ _ _ __ _ _ _ _ ___ ______________________________
>(( /\\ /\\ ||) |\V/| /\\ /\\ >/ Principal Performance Engineer
>_))//-\\//-\\||\ |||||//-\\\\//<_ Oracle Corporation Compaq SBU
>////////////////// Drop x's in email (spam) //////////////////////
>
>
>
Received on Thu Aug 06 1998 - 07:47:53 CDT