Oracle Text Index Objects Starting With "DRC$" Do Not Get Renamed Correctly On 11.2.0.4 And 12.1.0.1 (Doc ID 1600877.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Text - Version 11.2.0.4 to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

Oracle text index objects starting with "DRC$" do not get renamed correctly (12c)

SQL> column object_name format a32
SQL> column object_type format a16
SQL> select object_name,object_type from all_objects where object_name like 'DR%$TEST%';

no rows selected

SQL> create table test (col1 varchar2(10), col2 varchar2(10));

Table created.

SQL> create index test_index on test(col1) indextype is ctxsys.context;

Index created.

SQL> select object_name,object_type from all_objects where object_name like 'DR%$TEST%';

OBJECT_NAME OBJECT_TYPE
-------------------------------- ----------------
DR$TEST_INDEX$I TABLE
DR$TEST_INDEX$K TABLE
DR$TEST_INDEX$R TABLE
DRC$TEST_INDEX$R INDEX
DR$TEST_INDEX$N TABLE
DR$TEST_INDEX$X INDEX

6 rows selected.

SQL> alter index test_index rename to test2_index;

Index altered.

SQL> select object_name,object_type from all_objects where object_name like 'DR%$TEST%';

OBJECT_NAME OBJECT_TYPE
-------------------------------- ----------------
DR$TEST2_INDEX$R TABLE
DR$TEST2_INDEX$N TABLE
DR$TEST2_INDEX$X INDEX
DRC$TEST_INDEX$R INDEX
DR$TEST2_INDEX$I TABLE
DR$TEST2_INDEX$K TABLE

6 rows selected.

SQL>

In the above example DRC$TEST_INDEX$R should have been renamed to DRC$TEST2_INDEX_R

Cause

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