ORA-01502: An index or partition of such an index is in an unusable state

In Oracle, the ROWID example performs a

Alter Table ACTOR move tablespace users;

An error was later executed when inserting a statement on the actor table

INSERT  into "SAKILA". " ACTOR "(" First_Name "," last_name "," last_update ")VALUES(' Zhang '' three  ', sysdate);

Error message

ORA-01502: An index or partition of such an index is in an unusable state

Reason

This problem may occur when someone moves over the table, or disable the index.
1. ALTER TABLE XXXXXX move tablespace xxxxxxx Command, the index will be invalidated.
2. Alter index index_name unusable, the command invalidates the indexes.

Workaround:

Rebuilding indexes

Alter index index_name rebuild online;

ORA-01502: An index or partition of such an index is in an unusable state