How to fix the Oracle error ORA-25185: index column other than last can not be specified for INCLUDE clause?

In this post, you’ll learn more about the Oracle ErrorORA-25185: index column other than last can not be specified for INCLUDE clause with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-25185: index column other than last can not be specified for INCLUDE clause

Reason for the Error ORA-25185: index column other than last can not be specified for INCLUDE clause

An index column name other than the last is specified as including column

How to fix the Error ORA-25185: index column other than last can not be specified for INCLUDE clause ?

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

Specify either a column name which is not part of index-organized table primary key index , or the last key column of the primary key for the INCLUDING clause.