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]
Printable View
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'
Thanks a lot...the query actualy works out like this:Quote:
Originally posted by Sameer
Code:column "created"
SELECT * FROM dba_objects WHERE object_type = 'INDEX'
select timestamp from dba_objects where object_name='objectname' AND OBJECT_TYPE='INDEX';