Re: dbms_scheduler.create_file_watcher
From: Adrian <bulleid_at_ku.gro.lioff>
Date: Fri, 19 Oct 2012 17:03:18 +0100
Message-ID: <1F5Mr4BGnXgQFwtP_at_ku.gro.lloiff>
In message <pan.2012.10.19.00.13.34_at_gmail.com>, Mladen Gogala <gogala.mladen_at_gmail.com> writes
>On Thu, 18 Oct 2012 19:58:49 +0100, Adrian wrote:
>
>> Jonathan is right in his assumption, I would like to be able to load
>> files as soon as I spot that they have arrived, whilst this could be
>> done using cron and a script of some form. Whilst I have nothing
>> against doing things at OS level, there seems some logic in allowing the
>> DB to do it if possible.
>
>Adrian, as far as I know, there is nothing like that in the database. If
>you come to think of it, databases are unlikely to have things like that
>because monitoring file needs kernel call to monitor inode, which is
>precisely what Inotify is. I doubt that there is an elegant way of doing it
>in the database.
>
>
>
Date: Fri, 19 Oct 2012 17:03:18 +0100
Message-ID: <1F5Mr4BGnXgQFwtP_at_ku.gro.lloiff>
In message <pan.2012.10.19.00.13.34_at_gmail.com>, Mladen Gogala <gogala.mladen_at_gmail.com> writes
>On Thu, 18 Oct 2012 19:58:49 +0100, Adrian wrote:
>
>> Jonathan is right in his assumption, I would like to be able to load
>> files as soon as I spot that they have arrived, whilst this could be
>> done using cron and a script of some form. Whilst I have nothing
>> against doing things at OS level, there seems some logic in allowing the
>> DB to do it if possible.
>
>Adrian, as far as I know, there is nothing like that in the database. If
>you come to think of it, databases are unlikely to have things like that
>because monitoring file needs kernel call to monitor inode, which is
>precisely what Inotify is. I doubt that there is an elegant way of doing it
>in the database.
>
>
>
Thanks for the follow up, the file watcher, and a corresponding routine (I think the documentation shows a good starting point) looked ideal, but if we need to provide a password (not unreasonable), then we could be sunk. It is looking like plan B (a cron job).
Adrian
-- To Reply : replace "bulleid" with "adrian" - all mail to bulleid is rejected Sorry for the rigmarole, If I want spam, I'll go to the shops Every time someone says "I don't believe in trolls", another one dies.Received on Fri Oct 19 2012 - 18:03:18 CEST