Trying to shrink space on a table and getting the error message
ORA-10631: SHRINK clause should not be specified for this object
Issue: The table has got a functional based index.
Solution:
Get the DDL for the index.
Remove the index
Perform the shrink operation
re-create the index
ORA-10631: SHRINK clause should not be specified for this object
Issue: The table has got a functional based index.
Solution:
Get the DDL for the index.
Remove the index
Perform the shrink operation
re-create the index
No comments:
Post a Comment