I'd like to know when the ALL_SDO_INDEX_INFO view has changed.
From the documentation, even the 11g R2 docs I found it should <font color="red">not</font> contain the TABLE_OWNER field
So it should be like:
Name Null Type
------------------------------ -------- ---------------------------------------------
SDO_INDEX_OWNER VARCHAR2(32)
INDEX_NAME VARCHAR2(32)
TABLE_NAME NOT NULL VARCHAR2(30)
COLUMN_NAME VARCHAR2(2048)
SDO_INDEX_TYPE VARCHAR2(32)
SDO_INDEX_TABLE VARCHAR2(32)
SDO_INDEX_STATUS VARCHAR2(32)
But when I describe all_sdo_index_info (in 11g R2), it show the table_owner field.
Name Null Type
------------------------------ -------- ---------------------------------------------
SDO_INDEX_OWNER VARCHAR2(32)
INDEX_NAME VARCHAR2(32)
TABLE_OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
COLUMN_NAME VARCHAR2(2048)
SDO_INDEX_TYPE VARCHAR2(32)
SDO_INDEX_TABLE VARCHAR2(32)
SDO_INDEX_STATUS VARCHAR2(32)
Does anyone know at what release Oracle modified this view, I could not find any information in metalink or in the documentation.
The definition of this view can be found in md\admin\prvtimd.plb
Patrick
Edited by: pa**** on Jan 23, 2012 8:52 AM