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 MARCH 03, 2019
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document