Home » RDBMS Server » Server Administration » localy managed temporary tablespace
localy managed temporary tablespace [message #162633] Sun, 12 March 2006 12:55 Go to next message
eddie137
Messages: 6
Registered: March 2006
Junior Member
Hi all!!
I am having problems with localy managed temporary tablespace.ORACLE 9.2.0.5.
We are keep getting error 1652 .I increased tablespace size.Now is 21.8 G.
Is it possible to calculate what size it should be(temp tablespace,temporary)Is it possible to free up space in localy managed temporary tablespaces?Any formula?

Thanks.

Report message to a moderator

Re: localy managed temporary tablespace [message #162700 is a reply to message #162633] Mon, 13 March 2006 04:06 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
http://www.orafaq.com/faqdba.htm#TEMPSPACE

Report message to a moderator

icon7.gif  Re: localy managed temporary tablespace [message #162776 is a reply to message #162700] Mon, 13 March 2006 10:51 Go to previous message
eddie137
Messages: 6
Registered: March 2006
Junior Member
Thank you very much for help.Smile
But i actually wanted to find out if it's possible to calculate temp tablespace size to avoid errors ,meaning to be proactive not reactive?

Report message to a moderator

Previous Topic: Datafiles
Next Topic: dba_data_files
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

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