How to fix the Oracle error SQL*Loader-00258: Maximum number of SORTED INDEXES (number) exceeded on table string?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00258: Maximum number of SORTED INDEXES (number) exceeded on table string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00258: Maximum number of SORTED INDEXES (number) exceeded on table string

Reason for the Error SQL*Loader-00258: Maximum number of SORTED INDEXES (number) exceeded on table string

There are too many indexes in the SORTED INDEX clause. The message displays the maximum number that are permitted.

How to fix the Error SQL*Loader-00258: Maximum number of SORTED INDEXES (number) exceeded on table string ?

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

Reduce the number of indexes specified in the SORTED INDEX clause or use the conventional path load instead of the direct path load.