Re: dbms_scheduler.create_file_watcher
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 19 Oct 2012 00:13:34 +0000 (UTC)
Message-ID: <pan.2012.10.19.00.13.34_at_gmail.com>
On Thu, 18 Oct 2012 19:58:49 +0100, Adrian wrote:
Date: Fri, 19 Oct 2012 00:13:34 +0000 (UTC)
Message-ID: <pan.2012.10.19.00.13.34_at_gmail.com>
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.
-- Mladen Gogala http://mgogala.freehostia.comReceived on Fri Oct 19 2012 - 02:13:34 CEST