Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error "ORA-01408: such column list already indexed", when try to create index in Sql worksheet

User_ZNYJXMar 24 2022 — edited Mar 25 2022

In sqlDeveloper version 21.4.2.018, when trying to create index in SH schema in Sql worksheet:

CREATE INDEX CUSTOMERS_LAST_NAME_IDX ON customers(cust_last_name);

The error is raised:

CREATE INDEX CUSTOMERS_LAST_NAME_IDX ON customers(cust_last_name)
Error report -
ORA-01408: such column list already indexed

Then I tried to create it from within GUI , as in the next image and it's created successfully.
index.JPG

Comments
Post Details
Added on Mar 24 2022
1 comment
880 views