How to fix the Oracle error DRG-12300: an index with this column list already exists in the index set?

In this post, you’ll learn more about the Oracle ErrorDRG-12300: an index with this column list already exists in the index set with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

DRG-12300: an index with this column list already exists in the index set

Reason for the Error DRG-12300: an index with this column list already exists in the index set

Cause: You tried to add an index to an index set, but an index with the specified column list already exists

How to fix the Error DRG-12300: an index with this column list already exists in the index set ?

You can fix this error in Oracle by following the below steps

Action: None