index name behaviour

[MURALI KRISHNA]

hi all,

i quried the "user_indexes" table it displays some rows but one of the record is like below(i am mentioning only few columns of the user_indexes table)

index_name index_type table_owner
SYS_IL0000051360C00023$$ LOB SUBSCRIBER_DEV

table_name table_type
AS_ALERTS_CONFIG TABLE

my problem is why index name is like this"SYS_IL0000051360C00023$$"

my idea is if name starts with "sys_" it is oracle generated name .

i saw this type of naming in constraints but in constraints i found on which column the constraint is there

but here i was unable to see on which column this index is created

 

[William Robertson]

It's a LOB index - table SUBSCRIBER_DEV has a CLOB or BLOB column. Try this:

select * from user_lobs l
where  l.index_name = 'SYS_IL0000051360C00023$$';

 

[MURALI KRISHNA]

Yes William Robertson the table has column with clob data type....

Thank you for your valuble information and time

and The default name of the LOB index is SYS_ILxxx where xxxx is a hexadecimal number

but i am getting "SYS_IL0000051360C00023$$"

what's meaning of "$$" at end of the index name

thanks in advance for your valuble time...