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 18.104.22.168 to 22.214.171.124 [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!