Error
ORA-29885: domain index is defined on the column to be modified
Solution
Find problematic index;
SQL>
SELECT *
FROM dba_indexes
WHERE table_name = 'EMPLOYEES' AND index_type = 'DOMAIN'
Drop the index and try again;
SQL>
DROP INDEX HR.IDX_EMPLOYEE_NAME;
ORA-29885: domain index is defined on the column to be modified
Solution
Find problematic index;
SQL>
SELECT *
FROM dba_indexes
WHERE table_name = 'EMPLOYEES' AND index_type = 'DOMAIN'
Drop the index and try again;
SQL>
DROP INDEX HR.IDX_EMPLOYEE_NAME;