Oracle: DBA_LOBS

create table tq84_lob_index (
   id  integer,
   txt clob
);

column index_name   format a25
column index_type   format a10
column segment_name format a25

select
   ind.index_name,
   ind.index_type,
   lob.segment_name
from
   user_indexes  ind                                              join
   user_lobs     lob on ind.index_name   = lob.index_name
where
   ind.table_name = 'TQ84_LOB_INDEX' ;                                
--
-- INDEX_NAME                INDEX_TYPE SEGMENT_NAME            
-- ------------------------- ---------- -------------------------
-- SYS_IL0003416770C00002$$  LOB        SYS_LOB0003416770C00002$$  

drop table tq84_lob_index;

select
-- lob.table_name,
   lob.column_name,
   lob.in_row,
   lob.deduplication,
   lob.format,
   lob.chunk,
   lob.segment_name,
   lob.tablespace_name,
   lob.index_name,
   lob.pctversion,
   lob.retention,
   lob.freepools,
   lob.cache,
   lob.logging,
   lob.encrypt,
   lob.compression,
   lob.partitioned,
   lob.securefile,
   lob.segment_created,
   lob.retention_type,
   lob.retention_value
from
   user_lobs lob
where
   lob.table_name = '…';