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

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