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
Last updated on SEPTEMBER 13, 2013
Applies to:Oracle Text - Version 126.96.36.199 to 188.8.131.52 [Release 11.2 to 12.1]
Information in this document applies to any platform.
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.
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