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 > -- > //www.freelists.org/webpage/oracle-l >=0D -- //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 -- //www.freelists.org/webpage/oracle-l