How to fix the Oracle error DRG-10581: indirect datastores cannot be used with long or lob text columns?

In this post, you’ll learn more about the Oracle ErrorDRG-10581: indirect datastores cannot be used with long or lob text columns with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

DRG-10581: indirect datastores cannot be used with long or lob text columns

Reason for the Error DRG-10581: indirect datastores cannot be used with long or lob text columns

Cause: You tried to create an index on a long or lob column using an indirect datastore such as the file or url datastores

How to fix the Error DRG-10581: indirect datastores cannot be used with long or lob text columns ?

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

Action: Use direct datastore or a varchar column