Home » RDBMS Server » Server Administration » temp file
temp file [message #157619] Fri, 03 February 2006 09:46 Go to next message
risy_s
Messages: 44
Registered: September 2005
Location: Mumbai
Member
hi all

one of my disk has low space so have make all the datafile autoextend off but my temp file is autoextend on and and it is 100 % full size of temp file is near about 10 gb

what shoud i do

1,can i make temp file autoextend off(in this case i have to create another temp file in another partition)
2 or should i create new tempfile in another partition and then make it default and then delete old one

risy.......

Report message to a moderator

Re: temp file [message #157625 is a reply to message #157619] Fri, 03 February 2006 10:18 Go to previous message
aciolac
Messages: 242
Registered: February 2006
Senior Member
You can to recereate your tempfile with smaller size. This is the simplest.

Report message to a moderator

Previous Topic: ORA-00600: - Help please
Next Topic: unable 2 install oracle 8i on P4 machine
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 14:13:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.