Re: how to reset modified date of an object

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_at_gmail.com> To: oracle-l_at_freelists.org 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_at_yahoo.com
> onkarnath.tiwary_at_gmail.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l