column with data_type CLOB does not appear in user_ind_columns, why? [message #653060] |
Sat, 25 June 2016 08:32 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/f4105293cf7668d8b25d440964dfca1f?s=64&d=mm&r=g) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Frank Naude
Messages: 4580 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.
|
|
|
|
|
|
|
|
|