What is the value of changing database metadata, except for: 1) trying to hide something 2) trying to confuse other colleague dba's.. In general: don't update SYS tables (exceptions exist which makes this a rule :-) Regards, Andre v Winssen -----Oorspronkelijk bericht----- Van: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] Namens Onkar N Tiwary Verzonden: woensdag 15 juni 2005 8:15 Aan: oracle-l@xxxxxxxxxxxxx Onderwerp: how to reset modified date of an object hi all, I have one simple but interesting question: How to reset the modified date of an object in oracle database to its original date irrespective of the date it has been modified? -- Thanks & Regards, T. Onkar Nath Ph : +91-9826728111(Cell) to_onkar@xxxxxxxxx onkarnath.tiwary@xxxxxxxxx -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l