How about update sys.obj$ set mtime=ctime where obj#=<whatever> (in a test system of course) ----- Original Message ----- From: Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx> To: oracle-l@xxxxxxxxxxxxx Sent: Wed, 15 Jun 2005 02:15:01 -0400 Subject: 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