about status of local index in user_objects, user_ind_partitions

SQL> create table t1 (c1 number)

  2  partition by range (c1)

  3  (

  4   partition p1 values less than (maxvalue)

  5  );

Table created.

SQL>

SQL> create index i1 on t1(c1) local unusable;

Index created.

SQL> column object_name format a30

SQL> column subobject_name format a30

SQL> column index_name format a30

SQL> column partition_name format a30

SQL> select object_name, subobject_name, status from user_objects where object_name = 'I1';

OBJECT_NAME                    SUBOBJECT_NAME                 STATUS           

------------------------------ ------------------------------ -------          

I1                             P1                             VALID            

I1                                                            VALID            

SQL> select index_name, status from user_indexes where index_name = 'I1';

INDEX_NAME                     STATUS                                          

------------------------------ --------