date of creation of an index

[diwakar]

Originally posted by Sameer

column "created"

SELECT * FROM dba_objects WHERE object_type = 'INDEX'

Thanks a lot...the query actualy works out like this:

select timestamp from dba_objects where object_name='objectname' AND OBJECT_TYPE='INDEX';