How to fix the Oracle error DRG-52304: This operation requires Query Stats to be enabled for the index?

In this post, you’ll learn more about the Oracle ErrorDRG-52304: This operation requires Query Stats to be enabled for the index with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

DRG-52304: This operation requires Query Stats to be enabled for the index

Reason for the Error DRG-52304: This operation requires Query Stats to be enabled for the index

Cause: attempting to do an operation which required query stats option for the index to be enabled

How to fix the Error DRG-52304: This operation requires Query Stats to be enabled for the index ?

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

Action: Enable query stats option for the index using ctx_output.enable_query_stats()