Troubleshoot: a non-regular solution for “ORA-01502 index is in unusable state”

How an error caused by running analyze to a table with unusable indexes is solved with regular expressions and dbms_stats.
How an error caused by running analyze to a table with unusable indexes is solved with regular expressions and dbms_stats.