Oracle Text Index Objects Starting With "DRC$" Do Not Get Renamed Correctly On 11.2.0.4 And 12.1
(Doc ID 1600877.1)
Last updated on MARCH 03, 2019
Applies to:
Oracle Text - Version 11.2.0.4 to 12.1.0.2 [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
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 |