OraFAQ Forum: SQL & PL/SQL » How To Check The Index Creation Date(2 merged)

Home » SQL & PL/SQL » SQL & PL/SQL » How To Check The Index Creation Date(2 merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How To Check The Index Creation Date(2 merged) [message #420726]

Tue, 01 September 2009 15:26

wtolentino
Messages: 429
Registered: March 2005

Senior Member

i looked up on the all_indexes there's none that will tell me when the index was created. is there any other objects that i can looked up where i can see when the index was created?

thanks,
warren

Report message to a moderator

Re: How To Check The Index Creation Date [message #420728 is a reply to message #420726]

Tue, 01 September 2009 15:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

ALL_OBJECTS

Report message to a moderator

Re: How To Check The Index Creation Date(2 merged) [message #420745 is a reply to message #420726]

Wed, 02 September 2009 00:25

bishtoo
Messages: 20
Registered: August 2009

Junior Member

select last_ddl_time from user_objects where Object_name='Index_name';

-- If you alter index then Last_DDL_time will laso be refreshed with new date.

Report message to a moderator