Oracle Shrink space issue-alter table <table> reduces space, returns ORA-10631 error due to function-based indexes. Is there any workaround?

Question

I deleted some data from table TAB1. To claim the space that I perform

modify table TAB1 to enable row moving; > it is normal to change the tablespace TAB1; > ORA-10631: SHRINK clause should not be specified for this object

This is because there are function-based indexes in the table. We cannot shrink a table using function-based indexes. Any work exists for this problem.

Answer 1

A lower index was the most likely alternative:

• .

Answer 2

, FBI .