| How to reduce size of Temporary TableSpace [message #168905] |
Mon, 24 April 2006 02:04  |
jdhananjay
Messages: 2
Registered: April 2006
Location: india
|
Junior Member |
|
|
Hello,
There are 2 table spaces Order and Order_Temp and User is Make_Order.
Size of Order_Temp is more than 20GB. I need to reduce it.
User Order is assigned to above table spaces.
Please let me know how to reduce the size of Order_Temp table space.
|
|
|
|
| Re: How to reduce size of Temporary TableSpace [message #168920 is a reply to message #168905] |
Mon, 24 April 2006 03:42  |
deepa_balu
Messages: 74
Registered: March 2005
|
Member |
|
|
If you want a smaller temp tablespace then create a new temp tablespace using the configuration you want, then switch the user over. Once everyone has been switched over, drop the old temp tablespace.
The space 'used' in the temp tablespace never shrinks unless you shut down the instance
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
