A client called with an issue running a script from a 3rd party vendor.. He was getting Oracle error ORA-01502 while running the supplied script. The ORA-01502 is basically stating that there is an invalid index/partition.

A simple select on the dba_indexes table showed that there were several invalid indexes. After making note of the invalid indexes I rebuilt them with the following:

ALTER INDEX index_01 REBUILD;
ALTER INDEX index_02 REBUILD;
ALTER INDEX index_03 REBUILD;

After the indexes were rebuilt the script was able to run without error.

Share This