How to fix the Oracle error DRG-11141: CTX_DDL.REMOVE_MDATA() and CTX_DDL.ADD_MDATA() not allowed for MDATA Section string?

In this post, you’ll learn more about the Oracle ErrorDRG-11141: CTX_DDL.REMOVE_MDATA() and CTX_DDL.ADD_MDATA() not allowed for MDATA Section string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

DRG-11141: CTX_DDL.REMOVE_MDATA() and CTX_DDL.ADD_MDATA() not allowed for MDATA Section string

Reason for the Error DRG-11141: CTX_DDL.REMOVE_MDATA() and CTX_DDL.ADD_MDATA() not allowed for MDATA Section string

Cause: you tried to call CTX_DDL.REMOVE_MDATA() or CTX_DDL.ADD_MDATA() on a MDATA section which is created with ALLOW_ADD_REM parameter set to FALSE.

How to fix the Error DRG-11141: CTX_DDL.REMOVE_MDATA() and CTX_DDL.ADD_MDATA() not allowed for MDATA Section string ?

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

Action: do not call CTX_DDL.REMOVE_MDATA() or CTX_DDL.ADD_MDATA() on a MDATA section that is created with ALLOW_ADD_REM parameter set to FALSE.