Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Deleted lots of indexes but free space not showing in tablespace.

ZAR_DBAMay 20 2022

Oracle 12c SE
AIX 7.1
Hi,

I have deleted 100's of unused indexes, but the tablespace free space did not increase. Stayed at 98% full. Supposed to have deleted 500GB worth of indexes.
Command used:
drop index BAAN.TABLENAME;
What could be the reason? I understand the O/s space is not reclaimed but the free space in the tablespace should increase.

Added on May 20 2022

#general-database-discussions, #index

8 comments

955 views

2 mentions