Re: ora-01408 such column list already indexed

Posted by ErmanArslansOracleBlog on Jun 13, 2017; 10:59am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ora-01408-such-column-list-already-indexed-tp2801p2802.html

You have an index on that column.
you may not see it because the name of the index may be weird.. The index name may be starting with "BIN$"
This happens when you restore a table from recyclebin. Table name is restored as the original name, but trigger names and index names are restored with their recyclebin names..
Check dba_ind_columns/all_ind_columns, you will see the index when you query these views.
Drop that index using drop index "OWNER"."<index_name>" . For ex: drop index "PO"."BIN$DRERERERRE"
Then you will be able to create your new index on the relevant column.

Alternatively you can rename that index(name starting with BIN$) to "index name you want".