How to fix the Oracle error DRG-12607: only ctxsys can create MULTI_COLUMN preferences?

In this post, you’ll learn more about the Oracle ErrorDRG-12607: only ctxsys can create MULTI_COLUMN preferences with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

DRG-12607: only ctxsys can create MULTI_COLUMN preferences

Reason for the Error DRG-12607: only ctxsys can create MULTI_COLUMN preferences

Cause: In order to create a multi column datastore preference, the effective user must be ctxsys.

How to fix the Error DRG-12607: only ctxsys can create MULTI_COLUMN preferences ?

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

Action: contact your DBA to create the preference as ctxsys