Home » RDBMS Server » Server Administration » How to clear TEMP table space manually?
How to clear TEMP table space manually? [message #55927] Tue, 25 February 2003 01:07 Go to next message
Jimmy Lim
Messages: 6
Registered: February 2003
Junior Member
Hi,

My System TEMP tablespace grow and would to clear the TEMP tablespaces. I understand TEMP tablespace is maintain by "SMON". However, I couldn't wait until "SMON" is awake to perform the task. May I know is there anyway to CLEAR the TEMP tablespaces manually?

Report message to a moderator

Re: How to clear TEMP table space manually? [message #55931 is a reply to message #55927] Tue, 25 February 2003 05:48 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
restart the database
or
coalesce the tablespace

Report message to a moderator

Re: How to clear TEMP table space manually? [message #55956 is a reply to message #55927] Wed, 26 February 2003 12:10 Go to previous message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
alter tablespace TEMP default storage (pctincrease 0);

Report message to a moderator

Previous Topic: Oracle 8.1.7 server on Windows 2000, service terminated unexpectedly
Next Topic: Cloning to different platform
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 14 05:15:05 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.