Where does this index come from?
That is an index that was automatically generated for a constraint. Example:

SQL&gt; select index_name from user_indexes;

no rows selected

SQL&gt; create table t1(c1 number primary key);

Table created.

SQL&gt; select index_name from user_indexes;

INDEX_NAME
--------------------------------------------------------------------------------
SYS_C006380