date of creation of an index

Sir,

I would like to know the date when an index was created. What should I query to get this??

Thanks and Regards,

K.Diwakar

[Edited by diwakar on 10-04-2002 at 08:07 AM]

Code:

---

column "created"

SELECT * FROM dba_objects WHERE object_type = 'INDEX'

---

Quote:

---

Originally posted by Sameer

Code:

---

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';