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:

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