| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: TEMPORARY SEGMENTS
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 Wed Aug 05 1998 - 16:16:07 CDT
 |
 |