Re: how to reset modified date of an object

  • From: John Clarke <jclarke@xxxxxxxxxxxxxxx>
  • To: onkarnath.tiwary@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 15 Jun 2005 08:51:48 -0400

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

Other related posts: