Temp File [message #72752] |
Tue, 14 October 2003 07:15 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
kjl
Messages: 48 Registered: June 2003
|
Member |
|
|
Hi,
I have tempfile, which is 10Gb, can you say what is wrong and why that file is so big. (System is stabil and works fine).
BR -kjl-
|
|
|
Re: Temp File [message #72753 is a reply to message #72752] |
Tue, 14 October 2003 09:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Thiru
Messages: 1089 Registered: May 2002
|
Senior Member |
|
|
Cant tell if it is wrong or right . You may have created the temporary tablespace with autoextend and unlimited size(or 10GB max) for the associated temp files. You have the option of dropping and recreating the temp file with the desired size.
-Thiru
|
|
|
Re: Temp File [message #72760 is a reply to message #72753] |
Wed, 15 October 2003 04:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
-kjl-
Messages: 1 Registered: October 2003
|
Junior Member |
|
|
Yeah, there was a size limited on 10GB. I wonder if it is possible now recreate a new temp file which is limited on 500MB? Is it possible?
-kjl-
|
|
|
|
Re: Temp File [message #72764 is a reply to message #72760] |
Wed, 15 October 2003 07:30 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Thiru
Messages: 1089 Registered: May 2002
|
Senior Member |
|
|
You can also resize the tempfile..
thiru@9.2.0:SQL>select file#,bytes from v$tempfile;
FILE# BYTES
---------- ----------
1 62914560
1 row selected.
thiru@9.2.0:SQL>alter database tempfile 1 resize 50m;
Database altered.
thiru@9.2.0:SQL>select file#,bytes from v$tempfile;
FILE# BYTES
---------- ----------
1 52428800
1 row selected.
|
|
|