DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
  b=Ds7s0t29eeRbrCJh++0bnfCULKimL9Ir1CnCNrZY/C8hc9JhrFUcpOOLeF9g0q0HGimFQvFBe0sglMPDOOk+Z+D62Y/fu/VKTwpQ/VzKJeaHK0MMO4FX2UI9Ok/Jv0BYvrBvj9EF4Y3fx8d+ww6VNGQWulFwdMVCe+f/9qknp6g=;
Date: Wed, 28 Nov 2007 10:53:00 -0800 (PST)
From: Ajay Thotangare <ajayoraclel@yahoo.com>
Subject: Re: Deleting files from O/S older than 6 hours
To: Remigiusz Sokolowski <rems@wp-sa.pl>
Cc: oracle-l@freelists.org
In-Reply-To: <474D4E95.1010308@wp-sa.pl>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-516146328-1196275980=:57417"
Message-ID: <164708.57417.qm@web57515.mail.re1.yahoo.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: ajayoraclel@yahoo.com
--0-516146328-1196275980=:57417
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Yes, I am using this option now. 
  Another problem is get the date/time for creating file 6hours before time.
  Currently I managed to do this by doing to_char(sysdate-6/24,'mmddhh24mi') in sqlplus and getting value in unix shell variable. Is there any way I can minus 6 hours from current date/time in unix and get in format mmddhh24mi ?
  Thanks for your help


Remigiusz Sokolowski <rems@wp-sa.pl> wrote:
  Ajay Thotangare wrote:
> Hi,
> 
> I am using following command to delete files from o/s older than 24 hours.
> /usr/bin/find /u01/log/*.log -mtime +0 -exec ls -l {} \;
> 
> Is there any way I can delete files older than 6 hours. I am using 
> HP-UNIX. I tried using
> /usr/bin/find /u01/log/*.log -mtime +0.4 -exec ls -l {} \;
> Above command does not work.
> 
may be there is option -newer on HP-UX (I don't have any such box here) 
- if so, one can touch fake file with proper time
Then find will operate on files newer than fake file

-- 

------------------------------------------------------------------------
Remigiusz Sokolowski 
WP/PTI/DIP/ZAB (+04858) 52 15 770
MySQL v04.x,05.x; Oracle v10.x

Zastrzezenia:
1. Wylaczenie danej funkcjonalnosci oznacza, ze niezwlocznie przystapimy
lub juz pracujemy nad jej uruchomieniem
2. Niniejsza wiadomosc stanowi jedynie wyraz prywatnych pogladow autora 
i nie jest w zadnym wypadku zwiazana ze stanowiskiem przedsiebiorstwa 
Wirtualna Polska S.A.
------------------------------------------------------------------------


WIRTUALNA POLSKA SA, ul. Traugutta 115c, 80-226 Gdansk; NIP: 957-07-51-216; 
Sad Rejonowy Gdansk-Polnoc KRS 0000068548, kapital zakladowy 62.880.024 zlotych (w calosci wplacony)


---------------------------------
Get easy, one-click access to your favorites.  Make Yahoo! your homepage.
--0-516146328-1196275980=:57417
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<DIV>Yes, I am using this option now. </DIV>  <DIV>Another problem is get the date/time for creating file 6hours before time.</DIV>  <DIV>Currently I managed to do this by doing to_char(sysdate-6/24,'mmddhh24mi') in sqlplus and getting value in unix shell variable. Is there any way I can minus 6 hours from current date/time in unix and get in format mmddhh24mi ?</DIV>  <DIV>Thanks for your help<BR><BR><BR><B><I>Remigiusz Sokolowski &lt;rems@wp-sa.pl&gt;</I></B> wrote:</DIV>  <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Ajay Thotangare wrote:<BR>&gt; Hi,<BR>&gt; <BR>&gt; I am using following command to delete files from o/s older than 24 hours.<BR>&gt; /usr/bin/find /u01/log/*.log -mtime +0 -exec ls -l {} \;<BR>&gt; <BR>&gt; Is there any way I can delete files older than 6 hours. I am using <BR>&gt; HP-UNIX. I tried using<BR>&gt; /usr/bin/find /u01/log/*.log -mtime +0.4 -exec ls -l {} \;<BR>&gt; Above command does not
 work.<BR>&gt; <BR>may be there is option -newer on HP-UX (I don't have any such box here) <BR>- if so, one can touch fake file with proper time<BR>Then find will operate on files newer than fake file<BR><BR>-- <BR><BR>------------------------------------------------------------------------<BR>Remigiusz Sokolowski <REMS@WP-SA.PL><BR>WP/PTI/DIP/ZAB (+04858) 52 15 770<BR>MySQL v04.x,05.x; Oracle v10.x<BR><BR>Zastrzezenia:<BR>1. Wylaczenie danej funkcjonalnosci oznacza, ze niezwlocznie przystapimy<BR>lub juz pracujemy nad jej uruchomieniem<BR>2. Niniejsza wiadomosc stanowi jedynie wyraz prywatnych pogladow autora <BR>i nie jest w zadnym wypadku zwiazana ze stanowiskiem przedsiebiorstwa <BR>Wirtualna Polska S.A.<BR>------------------------------------------------------------------------<BR><BR><BR><BR>WIRTUALNA POLSKA SA, ul. Traugutta 115c, 80-226 Gdansk; NIP: 957-07-51-216; <BR>Sad Rejonowy Gdansk-Polnoc KRS 0000068548, kapital zakladowy 62.880.024 zlotych (w calosci
 wplacony)<BR></BLOCKQUOTE><BR><p>&#32;
      <hr size=1>Get easy, one-click access to your favorites. 
<a href="http://us.rd.yahoo.com/evt=51443/*http://www.yahoo.com/r/hs"> Make Yahoo! your homepage.</a>


--0-516146328-1196275980=:57417--

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