ctx_ddl.drop_shadow_index, ctx_ddl.drop_shadow_index, ctx_ddl.recreate_index_online do not work when run from an Account other than Index Owner (Doc ID 1567309.1)

Last updated on SEPTEMBER 13, 2013

Applies to:

Oracle Text - Version 11.2.0.2 to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

When connected as a different user, non-index owner, the shadow index is not dropped although no error is indicated.
This issue cascades to other ctx_ddl APIs, ie CTX_DDL.CREATE_SHADOW_INDEX, CTX_DDL.DROP_SHADOW_INDEX, CTX_DDL.EXCHANGE_SHADOW_INDEX and CTX_DDL.RECREATE_INDEX_ONLINE.

The workaround is to connect as index owner when calling above APIs.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms