Home » SQL & PL/SQL » SQL & PL/SQL » How To Check The Index Creation Date(2 merged)
How To Check The Index Creation Date(2 merged) [message #420726] Tue, 01 September 2009 15:26 Go to next message
wtolentino
Messages: 422
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
Re: How To Check The Index Creation Date [message #420728 is a reply to message #420726] Tue, 01 September 2009 15:38 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
ALL_OBJECTS
Re: How To Check The Index Creation Date(2 merged) [message #420745 is a reply to message #420726] Wed, 02 September 2009 00:25 Go to previous messageGo to next message
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.
Re: How To Check The Index Creation Date(2 merged) [message #420749 is a reply to message #420745] Wed, 02 September 2009 00:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
If you alter index then Last_DDL_time will laso be refreshed with new date.

So it is better to query CREATED column.

Regards
Michel
Re: How To Check The Index Creation Date(2 merged) [message #420844 is a reply to message #420726] Wed, 02 September 2009 10:31 Go to previous message
wtolentino
Messages: 422
Registered: March 2005
Senior Member

thank you all. the all_objects and user_objects is very helpful.
Previous Topic: Newbie two table update question
Next Topic: regex_like number, *, -
Goto Forum:
  


Current Time: Thu Feb 06 09:33:53 CST 2025