Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: how to reset modified date of an object

RE: how to reset modified date of an object

From: Yasin Baskan <yasbs_at_kocbank.com.tr>
Date: Wed, 15 Jun 2005 16:30:53 +0300
Message-ID: <083667B535F3464CA0DD0D1DAFA4E3760647D654@camexc1.kfs.local>

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

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Clarke Sent: Wednesday, June 15, 2005 3:52 PM
To: onkarnath.tiwary_at_gmail.com; oracle-l_at_freelists.org 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)

> 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_at_yahoo.com
> onkarnath.tiwary_at_gmail.com

>=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
Received on Wed Jun 15 2005 - 09:34:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US