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
Oracle Text - Version 184.108.40.206 to 220.127.116.11 [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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!