ORA-14530
Rows in table table_schema_name.table_name do not match entries in index index_schema_name.index_name.
- table_schema_name: The schema in which the table resides.
- table_name: The table name.
- index_schema_name: The schema in which the index resides.
- index_name: The index name.
Cause
The table and the index that the operation tried to use had inconsistent information about the rows.
Action
The inconsistency needs to be resolved in order to continue using the table with the index. An inconsistency can occur due to different reasons.
Run the ANALYZE command with the CASCADE option on the table to determine the inconsistent object and rows.
If the corrupt rows are in the table, fix the data corruption.
If the index is corrupt, an index REBUILD may resolve the corruption. Also consider dropping the index or marking it UNUSABLE.