| Temp File [message #72752] |
Tue, 14 October 2003 07:15  |
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  |
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 |
-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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
