Oracle Error Message
ORA-29953: cannot issue DDL on a domain index partition marked as FAILED
Reason for the Error
Tried to issue a DROP/ALTER on a domain index partition in a FAILED state.
Solution
do ALTER INDEX REBUILD PARTITION to rebuild the index partition OR ALTER TABLE TRUNCATE PARTITION to mark the index partition as valid.
Leave a Review