| How to manage tablespace for indexes [message #261786] |
Thu, 23 August 2007 10:46  |
rookiedba
Messages: 11
Registered: March 2007
Location: Montana
|
Junior Member |
|
|
Hi there all,
I am managing tablespaces in OLAP and OLTP databases. Tablespaces for tables is manageable, as I am truncating tables (of oldest partition) in a certain table tablespace with DROP STORAGE clause to relieve of space within that tablespace. That worked just fine.
My question is regarding the tablespace for indexes. If indexes are growing in a tablespace, how do I manage them so that the tablespace do not keep growing until they reach its max limits or OS diskspace for that data file.
I tried analyzing all all indexes in a particular index tablespace but could not gain any space in the table space.
Any thoughts/suggestions/recommendations/feedback will be greatly appreciated.
Thanks
RookieDBA
|
|
|
|
|
|
| Re: How to manage tablespace for indexes [message #261798 is a reply to message #261786] |
Thu, 23 August 2007 11:20  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
When you truncate table, indexes are also truncated.
If you want to get back the space to tablespace then you can rebuild the indexes which is very fast after a truncate.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
