Oracle database server 11.2.0.3.7 on AIX 7.1.
Oracle Enterprise Manager 12c
I am going to use OEM 12c to shrink a 5 GB table to reclaim some space. The table contains 18 million rows. It has ten bitmap indexes.
OEM asks me if I want to, "Shrink <table> Only" or "Shrink <table> and All Dependent Segments". I believe the indexes contain rowids which will change because of the shrink on the table, so they will become unusable. What is the right way to handle the indexes? Do I drop them before the shrink then recreate them afterwards, or do I do something else to them?
Thank you,
Bill