Re: Problem with User TEMP space

Hi,
If you are atlking about temp tablespace, you need to check the database setting of auto extend is on or not. If it is on,
then yor tablespace will grow according to your data processing requiremrnts and it will not shrink automatically unless you do it manually. One work around is, turn auto extend property on when you have large data processing jobs and after you finish, you can shrink its size.

HTH Madhu Cherukuri

guan.lee_at_telops.gte.com wrote in message <6d53ha$f87$1_at_nnrp1.dejanews.com>...
>I am running Oracle 8.0.3 on NT. After creating a large index (1.2 G), my
>user temp space size remains the same as 1.2 G. The index was created
>successfully but the user temp space didn't go away until I recycled my
>machine. When temp space is emptying out, the oracle is using most of my
>machine's resource and users have trouble to connect to it. Does anyone
 know
>how to set and let the system truncate the user temp space when index is
>created? or This is the bug of Oracle 8. Thanks for any advise.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Thu Feb 26 1998 - 00:00:00 CST