Re: I should know this....about temp segments tablespace

Vikas,

Notice that the quota portion is in an OPTIONAL bracket. :) Did you get your question answered?

Steve

In <31B58395.267E_at_mink.att.com> Vikas Agnihotri <vikas_at_mink.att.com> writes:
>
>Steve,
> I dont think that was the original question. Yes, the user
>profile must specify the temporary tablespace as <TEMP TABLESPACE>
>but ** NO QUOTA** is needed on that tablespace.
>
> A quota on a tablespace is needed ONLY IF objects are to be
>created in that tablespace.
> E.g. ALTER USER username quota 0 on <TEMP TABLESPACE>;
>
>Even after this, you will see that when the user needs temp
>segments they WILL get created in TEMP TABLESPACE, the reason being
>that these segments are owned by SYS and not by the user running
>the SQL statement.
>
>
>--Vikas Agnihotri
> vikas_at_mink.att.com
>Steve Long wrote:
>>
>> The user MUST be allocated use of a temporary tablespace or the
>> database will use SYSTEM (not good).
>>
>> alter user USERNAME temporary tablespace TEMP_TABLESPACE_NAME
 [quota..]
>>
>> (page 4-84 of ORACLE7 Server SQL Language Reference Manual)
>>
>> ---------------------------------------------
>>
Received on Wed Jun 05 1996 - 00:00:00 CEST