Steps to resolve ORA 14287 cannot REBUILD a partition
Introduction: – In this post we will cover ORA 14287 cannot REBUILD a partition. If any index status is unusable then we will have to identify the same and rebuilt as mentioned below. How to resolve ORA 14287 cannot REBUILD a partition? SQL>SELECT OWNER, INDEX_NAME,” FROM DBA_INDEXES WHERE STATUS = ‘UNUSABLE’ UNION SELECT INDEX_OWNER, INDEX_NAME, PARTITION_NAME FROM … Read more