Home » RDBMS Server » Server Administration » free space from temp tablespace oracle 8i
free space from temp tablespace oracle 8i [message #127360] Mon, 11 July 2005 06:59 Go to next message
reyazan
Messages: 53
Registered: February 2005
Member
I am using oracle 8i 1.7 on windows 2000.

Problem is My temp tablespace is full now

How to freeing up space from temp tablespace

please help

Report message to a moderator

Re: free space from temp tablespace oracle 8i [message #127363 is a reply to message #127360] Mon, 11 July 2005 07:02 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
HI

What is the error that you are getting becuase of this? For this error, do check the alert log for database.
If no error, its not an issue, while if error is there, u may need to make temp tablespace bigger.

Regds
Girish

Report message to a moderator

Re: free space from temp tablespace oracle 8i [message #127408 is a reply to message #127360] Mon, 11 July 2005 10:00 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Girish is right, we'd need to see the error. But the temp tablespace isn't something you manage, oracle does. So you don't free space from it. You make it as big as you need based on your workload and activity.

And you really should invest time in reading the concepts guide.

Report message to a moderator

Previous Topic: database create script from existing database
Next Topic: problem with date
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 13 11:04:40 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.