How to fix the Oracle error DRG-12240: ORDER BY column string must be indexed as an SDATA section?

In this post, you’ll learn more about the Oracle ErrorDRG-12240: ORDER BY column string must be indexed as an SDATA section with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

DRG-12240: ORDER BY column string must be indexed as an SDATA section

Reason for the Error DRG-12240: ORDER BY column string must be indexed as an SDATA section

Cause: an order by column has been mapped to an MDATA section

How to fix the Error DRG-12240: ORDER BY column string must be indexed as an SDATA section ?

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

Action: adjust section group