Database Administration (MOSC)

MOSC Banner

Dropping indexes and reclaiming space

edited Jul 2, 2009 3:24AM in Database Administration (MOSC) 7 commentsAnswered
 

have a question about indexes and space. More specifically, I'm wondering how to reclaim space once you drop an object like an index. My organization is running a database that contains a "sales" table that is partitioned by date. This is a huge table and it takes a lot of room just by itself. The "sales" table has five indexes that when combined take up more storage space than the data. I've confirmed that the indexes are not really being utilized and were created at a time when the user thought they would help speed up searches.

I would like to drop the indexes, which from what I understand will cascade all the way through the table (ie I cannot drop the index for individual partitions), and would like to know if doing so would release the storage on the physical space to be allocated for other objects.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center