column with data_type CLOB does not appear in user_ind_columns, why? [message #653060] |
Sat, 25 June 2016 08:32 |
|
gunderj
Messages: 17 Registered: April 2016 Location: California
|
Junior Member |
|
|
If you create a table with a column data_type of CLOB you will get an index of index_type LOB but somehow the column does not appear in user_ind_columns. Does anyone know why, or where else I could find the column in the dictionary? Thanks.
create table t(
x1 number,
x2 clob)
/
select table_name,index_name,index_type from user_indexes
where index_type = 'LOB'
/
select column_name from user_ind_columns
where column_name = 'X2'
/
|
|
|
Re: column with data_type CLOB does not appear in user_ind_columns, why? [message #653061 is a reply to message #653060] |
Sat, 25 June 2016 08:40 |
Frank Naude
Messages: 4579 Registered: April 1998
|
Senior Member |
|
|
Try: select * from user_indexes where table_name = 'T';
SQL> r
1* SELECT index_name, index_type, table_name FROM user_indexes WHERE table_name = 'T'
INDEX_NAME INDEX_TYPE TABLE_NAME
------------------------------ --------------------------- ------------------------------
SYS_IL0000074565C00002$$ LOB T
It's not associated with the column, but with the lob segment created for the column. Hence, no data in user_ind_columns.
|
|
|
|
|
|
|
|
|