Home » RDBMS Server » Backup & Recovery » How to manage tablespace for indexes
 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
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Mon Apr 07 09:45:20 CDT 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
