OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Temp file size (oracle,9i,SunOs)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Temp file size [message #291110]

Thu, 03 January 2008 01:00

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.

Report message to a moderator

Re: Temp file size [message #291119 is a reply to message #291110]

Thu, 03 January 2008 01:31

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Temp file size [message #291127 is a reply to message #291119]

Thu, 03 January 2008 01:51

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.

Report message to a moderator

Re: Temp file size [message #291130 is a reply to message #291127]

Thu, 03 January 2008 01:58

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ALTER USER

Regards
Michel

Report message to a moderator

Re: Temp file size [message #291626 is a reply to message #291130]

Sat, 05 January 2008 09:28

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;

Report message to a moderator

Re: Temp file size [message #291630 is a reply to message #291626]

Sat, 05 January 2008 09:47

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Web Console for Manually Created Database
Next Topic:	regarding oracle database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 05:13:10 CST 2024