col index_name format A16
col table_name format A16
select index_name, table_name, partitioned, to_char(last_analyzed,'DD/MM/YY HH24:MM:SS'), num_rows
from dba_indexes
where table_name = 'DFKKKO';
col SEGMENT_NAME format A16
col SEGMENT_TYPE format A16
select SEGMENT_NAME, SEGMENT_TYPE, BYTES from dba_segments
where segment_name = 'DFKKKO%';
