RE: how to reset modified date of an object


I would never think of modifying any system table. This may have
disastrous effects as i know.


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of John Clarke
Sent: Wednesday, June 15, 2005 3:52 PM
To: onkarnath.tiwary@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: how to reset modified date of an object

How about

update sys.obj$ set mtime=3Dctime where obj#=3D<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?=0D
> =0D
> --=0D
> Thanks & Regards,
> T. Onkar Nath
> Ph : +91-9826728111(Cell)
> to_onkar@xxxxxxxxx
> onkarnath.tiwary@xxxxxxxxx
>=0D
> --
> http://www.freelists.org/webpage/oracle-l
>=0D

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



Bu mesaj ve onunla iletilen tum ekler gonderildigi kisi ya da kuruma ozel=
 ve Bankalar Kanunu geregince, gizlilik yukumlulugu tasiyor olabilir. Bu=
 mesaj, hicbir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz=
 ve para karsiligi satilamaz; mesajin yetkili alicisi veya alicisina=
 iletmekten sorumlu kisi degilseniz, mesaj icerigini ya da eklerini=
 kopyalamayiniz, yayinlamayiniz, baska kisilere yonlendirmeyiniz ve mesaji=
 gonderen kisiyi derhal uyararak bu mesaji siliniz. Bu mesajin iceriginde=
 ya da eklerinde yer alan bilgilerin dogrulugu, butunlugu ve guncelligi=
 Bankamiz tarafindan garanti edilmemektedir ve bilinen viruslere karsi=
 kontrolleri yapilmis olarak yollanan mesajin sisteminizde yaratabilecegi=
 zararlardan Bankamiz sorumlu tutulamaz.

This message and the files attached to it are under the privacy liability=
 in accordance with the Banking Law and confidential to the use of the=
 individual or entity to whom they are addressed. This message cannot be=
 copied, disclosed or sold monetary consideration for any purpose. If you=
 are not the intended recipient of this message, you should not copy,=
 distribute, disclose or forward the information that exists in the content=
 and in the attachments of this message; please notify the sender=
 immediately and delete all copies of this message. Our Bank does not=
 warrant the accuracy, integrity and currency of the information=
 transmitted with this message. This message has been detected for all=
 known computer viruses thence our Bank is not liable for the occurrence of=
 any system corruption caused by this message
--
http://www.freelists.org/webpage/oracle-l

Other related posts: