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:

> 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.com
Received on Fri Oct 19 2012 - 02:13:34 CEST

Original text of this message