Skip to Main Content

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!

Cleanup Database tables

user12255470Nov 17 2021 — edited Nov 17 2021

Hi,
I have multiple tables with lot of delete operations (around 100k rows) every alternate days.

which is causing lot of empty blocks to the tables.
so I am doing the shrink space on those tables manually to rearrange the empty blocks.

is there anyway I can automate this process for all tables with any provided utility?

Comments
Post Details
Added on Nov 17 2021
8 comments
940 views