To my knowledge the only date that you can get is the last analyzed date.
Code:1 select owner, table_name, column_name 2 from dba_tab_columns where data_type='DATE' 3 and table_name like '%IND%' 4* and owner='SYS' SQL> / OWNER TABLE_NAME COLUMN_NAME ----- ------------------------------ ------------- SYS ALL_INDEXES LAST_ANALYZED SYS ALL_IND_PARTITIONS LAST_ANALYZED SYS ALL_IND_SUBPARTITIONS LAST_ANALYZED SYS DBA_INDEXES LAST_ANALYZED SYS DBA_IND_PARTITIONS LAST_ANALYZED SYS DBA_IND_SUBPARTITIONS LAST_ANALYZED SYS IND$ ANALYZETIME SYS IND$ SPARE6 SYS INDCOMPART$ ANALYZETIME SYS INDPART$ ANALYZETIME SYS INDSUBPART$ ANALYZETIME SYS KU$_INDEX_COL_VIEW SPARE6 SYS KU$_INDEX_VIEW ANALYZETIME SYS KU$_INDEX_VIEW SPARE6 SYS KU$_IND_COMPART_VIEW ANALYZETIME SYS KU$_IND_PART_VIEW ANALYZETIME SYS KU$_IND_SUBPART_VIEW ANALYZETIME SYS USER_INDEXES LAST_ANALYZED SYS USER_IND_PARTITIONS LAST_ANALYZED SYS USER_IND_SUBPARTITIONS LAST_ANALYZED 20 rows selected.




Reply With Quote