Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> When was an index last rebuilt?
This is a multi-part message in MIME format.
------=_NextPart_000_0000_01C074CD.C0B24480
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: 7bit
Can anybody help me identify when an index was last built please
I can tell when an index was created or ddl changed from user_indexes but I cannot see any way of telling when the index was last built. Has anybody any thoughts on this please.
Thanks in advance
John
------=_NextPart_000_0000_01C074CD.C0B24480
Content-Type: application/ms-tnef;
name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="winmail.dat"
eJ8+IikPAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANEHAQACAA8ABgAAAAIA8gAB A5AGAGAFAAAlAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB AAAAIAAAAFdoZW4gd2FzIGFuIGluZGV4IGxhc3QgcmVidWlsdD8AAgFxAAEAAAAWAAAAAcB0zY0y /igNA+C/EdSlPewXTvJTNwAAAgEdDAEAAAAaAAAAU01UUDpKT0hOLkhBTExBU0BNQUlMLkNPTQAA AAsAAQ4AAAAAQAAGDgA8HYTNdMABAgEKDgEAAAAYAAAAAAAAAAuCtU6rOr8Rln4Sra6l4urCgAAA CwAfDgEAAAACAQkQAQAAADgBAAA0AQAAqgEAAExaRnXhl/ZlAwAKAHJjcGcxMjUmMgD4C2BuZwHQ NTdPAfcCpAPjAgBjaArAc7BldDAgBxMCgH0KgZJ2CJB3awuAZDQMYM5jAFALAwu1IEMDkQBwAnkG 4GR5IGhlbORwIAeAIGkBAAIwBpA9FHB3FJAT8hUAEoBleC0VkGEEIAtgcwVAYnXXAxAFQAtQZRaQ ZQqiCoTRCoBJIGMDkXQUoAMglxWvGKAJcGEY8GQgBbF8ZGQDIBDhDyAasQNSIPJ1ESByXxYjB5EX EAVA+RiTbm8FQBEgFPAUERZxsRRwb2YgGOMLgGcZNI50FJAWHxciLiBIFpGPFBYeAh+QCGBnaHQE IK8CIB+BBAAXZS4X2lQbYU5rBCALgBQAZHYAcGPjF8sX1EpvaAOhF+MR4QIAJ5ALAACACCAGAAAA AADAAAAAAAAARgAAAAADhQAAAAAAAAMAAoAIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAAAAAAAwAF gAggBgAAAAAAwAAAAAAAAEYAAAAAUoUAACdqAQAeACWACCAGAAAAAADAAAAAAAAARgAAAABUhQAA AQAAAAQAAAA5LjAAAwAmgAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAALAC+ACCAGAAAAAADA AAAAAAAARgAAAAAOhQAAAAAAAAMAMIAIIAYAAAAAAMAAAAAAAABGAAAAABGFAAAAAAAAAwAygAgg BgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAAeAEGACCAGAAAAAADAAAAAAAAARgAAAAA2hQAAAQAA AAEAAAAAAAAAHgBCgAggBgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAAAAAAAB4AQ4AIIAYA AAAAAMAAAAAAAABGAAAAADiFAAABAAAAAQAAAAAAAAALANaACCAGAAAAAADAAAAAAAAARgAAAAAG hQAAAAAAAAsA2oAIIAYAAAAAAMAAAAAAAABGAAAAAIKFAAABAAAAAgH4DwEAAAAQAAAAC4K1Tqs6 vxGWfhKtrqXi6gIB+g8BAAAAEAAAAAuCtU6rOr8Rln4Sra6l4uoCAfsPAQAAAFAAAAAAAAAAOKG7 EAXlEBqhuwgAKypWwgAAUFNUUFJYLkRMTAAAAAAAAAAATklUQfm/uAEAqgA32W4AAABDOlxXSU5E T1dTXG91dGxvb2sucHN0AAMA/g8FAAAAAwANNP03AAACAX8AAQAAADQAAAA8TFBCQkpHSE9CSkNQ QkxPTEVKTkFHRUhLREZBQS5qb2huLmhhbGxhc0BtYWlsLmNvbT4AAwAGEDWqKQoDAAcQ1QAAAAMA EBAAAAAAAwAREAAAAAAeAAgQAQAAAGUAAABDQU5BTllCT0RZSEVMUE1FSURFTlRJRllXSEVOQU5J TkRFWFdBU0xBU1RCVUlMVFBMRUFTRUlDQU5URUxMV0hFTkFOSU5ERVhXQVNDUkVBVEVET1JERExD SEFOR0VERlJPTVVTAAAAAC0L Received on Tue Jan 02 2001 - 09:07:39 CST
![]() |
![]() |