Hmmm ... if the database is down? do you have to reset the time to process
the now older files?

Could the same thing be done via DBMS_JOB?

Regards
Amin Adatia ([Email address protected]
KnowTech Solutions Inc. (www.knowtech.ca)
(613) 226-8378 Mobile (613) 864-8378
----- Original Message -----
From: "Walter Hunnel "
<oracledba-ezmlmshield-x9836333.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, May 31, 2007 4:00 PM
Subject: RE: scripts


>A process I use is to process all the files in the directory, touch a
> dummy file, then check again in a minute (every minute) and process any
> files newer than the dummy file, touch the dummy file, rince, repeat.
>
> A new file comes in in 8 minutes? Fine, the 9 minute check will catch
> it. 12 minutes? OK, the 13 minute check will get it.
>
> No file will 'sit and wait' for more than 60 seconds before being
> processed.
>
> This works based on file creation time only, without reguard to the file
> name (although you can use the file name without difficulty...)
>
> I use touch and find in my cron script. MAN FIND and MAN TOUCH will get
> you details.
>
> I use the ! -newer parameter to TOUCH
>
> HTH
>
> Walt
>
>
>
> Confidentiality Notice: This e-mail message, including any attachments, is
> for the sole use of the intended recipient(s) and may contain confidential
> and privileged information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the intended recipient, please
> contact the sender by reply e-mail and destroy all copies of the original
> message.
>
>
> From: Zelli Brian
> [mailto:oracledba-ezmlmshield-x14480005.[Email address protected]
> Sent: Thursday, May 31, 2007 14:49
> To: LazyDBA Discussion
> Subject: scripts
>
> Ok, I need to sqlload files as they come into a directory. They come in
> every ten minutes. But it is not a set ten minutes. Only when there is
> data to pump across. Does anyone have a unix script that can
> accommodate something like this? the files come in with a timestamp as
> part of the name. I was able to cron a job that handled a once a day
> process but not something like this. Or if you have ideas, white
> papers, website that I can look at.........
>
> ciao,
> Brian
>
>
>
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee
> or agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>


Oracle LazyDBA home page