My Oracle Support Banner

ctx_ddl.drop_shadow_index does not drop shadow index (Doc ID 1375101.1)

Last updated on NOVEMBER 08, 2011

Applies to:

Oracle Text - Version: 11.1.0.6 to 11.2.0.1 - Release: 11.1 to 11.2
Information in this document applies to any platform.

Symptoms

Executing ctx_ddl.drop_shadow_index completes without errors however, the shadow index is not dropped:

SQL> select idx_id,idx_name from ctx_user_indexes;

IDX_ID     IDX_NAME
---------- ------------------------------
      1100 QUICK_TEXT

SQL> exec ctx_ddl.create_shadow_index('quick_text');

PL/SQL procedure successfully completed.

SQL> select idx_id,idx_name from ctx_user_indexes;

IDX_ID     IDX_NAME
---------- ------------------------------
      1100 QUICK_TEXT
      1101 RIO$1100

SQL> exec ctx_ddl.drop_shadow_index('RIO$1100')

PL/SQL procedure successfully completed.

SQL> exec ctx_ddl.create_shadow_index('quick_text');
BEGIN ctx_ddl.create_shadow_index('quick_text'); END;
*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-13501: Shadow Index Already Exists
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 1560
ORA-06512: at line 1

SQL> select idx_id,idx_name from ctx_user_indexes;

IDX_ID     IDX_NAME
---------- ------------------------------
      1100 QUICK_TEXT
      1101 RIO$1100

Cause

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
  Symptoms
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.