Re: TEMPORARY SEGMENTS

Craig M. Wall wrote in message <6qc8ic$oa_at_news9.noc.netcom.net>...
>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.
>

I remember that I read from somewhere that once you turn that tablespace into a temporary one, it will automatically have unlimited maximum extent. So the problem is not changing the number of the maximum extent but to add another datafile into the temp tablespace.

Winnie

>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 Fri Aug 07 1998 - 20:54:08 CDT