Database Administration (MOSC)

MOSC Banner

reclaim space in an index tablespace

I have Oracle rac 19c on linux 7 with 2 nodes database 19.3

i have 1 tablespace for indexes for a schema on another tablespace,

the schema tablespace is being cleaned and storage reclaimed after i issue alter table drop partition update indexes on regular basis, after this is run only the schema tablespace has storage reclaimed while the tablespace containing the indexes is not

why is the storage not reclaimed from the index tablespace knowing that the tables the partitioned are dropped from has the biggest indexes


Regards

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