Home » RDBMS Server » Server Administration » Temp file size (oracle,9i,SunOs)
Temp file size [message #291110] Thu, 03 January 2008 01:00 Go to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Hi,
My temp file size is more in particular filesystem, Can I delete this file? Or do I need to do anything for this? Is there any problem if i delete this file?

Thanks.
Re: Temp file size [message #291119 is a reply to message #291110] Thu, 03 January 2008 01:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create a new temp tablespace, assign the users to this new temp tablespace, delete the previous one.
You can't drop a file on the fly unless you are in 10g or more.

Regards
Michel
Re: Temp file size [message #291127 is a reply to message #291119] Thu, 03 January 2008 01:51 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Thanks Michel.

could you tell how to assign all the existing user to the new temp tablespace at one shot?

Thanks.
Re: Temp file size [message #291130 is a reply to message #291127] Thu, 03 January 2008 01:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ALTER USER

Regards
Michel
Re: Temp file size [message #291626 is a reply to message #291130] Sat, 05 January 2008 09:28 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Or you can assign at database level.
alter database default temporary tablespace tbsname;
Re: Temp file size [message #291630 is a reply to message #291626] Sat, 05 January 2008 09:47 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Only if the previous temporary tablespace was the default one.
I mean you can do it if it was not the case but in this case this does not change the user temporary tablespace.

Regards
Michel
Previous Topic: Web Console for Manually Created Database
Next Topic: regarding oracle database
Goto Forum:
  


Current Time: Sat Dec 03 20:13:15 CST 2016

Total time taken to generate the page: 0.09305 seconds