Fix the index with status unusable and statusunusable

Fix the index with status unusable and statusunusable

Log On with the DBA permission and execute the following script.

Declare
-- Cursor pointing to the index of all UNUSABLE states
Cursor c is
Select index_name, owner
From dba_indexes
Where status = 'unusable ';

Owner dba_indexes.owner % type;
Index_name dba_indexes.index_name % type;
Begin
Open c;
Loop
Fetch c into index_name, owner;
Exit when c % notfound;

Execute immediate 'alter Index' | owner | '.' | index_name | 'rebuilt ';
End loop;
Close c;
End;

<Td class = "td_title"> Function checkIdentityCard (obj ){
If (obj. value. length! = 18 ){
Alert ('not 18 bits ');
}
}
 
HTTP Status 500-javalangIndexOutOfBoundsException: Index: 0, Size: 0

Obviously, the array you are using has a problem. Maybe your List is not empty, but list. size () = 0. If you want to get the first value, there is no such error. When using list. get (0);, You need to judge list! = Null & list. size ()! = 0