| How to resize Temp tablespace ? [message #61999] |
Wed, 16 June 2004 22:59  |
Ravi
Messages: 251
Registered: June 1998
|
Senior Member |
|
|
My Temp tablespace has taken 11GB and it can not grow futher.I need to resize it.
I am using oracle 9i
I have tried creating another Temp tbs(made it default) , but nuable to delete the first one .Please suggest........
Thanks in advance
Ravi
|
|
|
|
| Re: How to resize Temp tablespace ? [message #62000 is a reply to message #61999] |
Thu, 17 June 2004 00:04  |
Anatol Ciolac
Messages: 113
Registered: December 2003
|
Senior Member |
|
|
|
You can add more files to existing tablespace. Adding yet one temporary tablespace will not help because you must also set clause 'temporary tablespace' of users, which will work on this new tablespace to new tablespace.
|
|
|
|
|
|
|
|
|
|
| Re: How to resize Temp tablespace ? [message #62009 is a reply to message #61999] |
Thu, 17 June 2004 07:08 |
N.A. Jam
Messages: 23
Registered: January 2003
|
Junior Member |
|
|
Maybe you can identify the statement that obviously is temp space hungry. If that is possible, then you probably can streamline the statement such that it would require less temporary segments. That usually is the case in my experience.
But, if you really have to allocate more space to temp and is limited in physical space, you might want to identify oversized tablespaces and trim them down to free up some disk space.
Hope this helps.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
