Re: dbms_scheduler.create_file_watcher

> 11.2 Linux
>
> I'm looking at using this to identify when I've got new files to load.
> At first glance it looks ideal, but on digging into the docs, it seems
> that I need to set up a credential, which is where I hit problems.
>
> The plan is that the files will be put in a directory owned by a user
> that we would be accessing using sudo rather than by logging in, so we
> won't know what the password is. No password, no credential, no
> credential, no file watcher appears to be the situation, or is there a
> (legitimate) way around it that I've missed ?.
>
>
> TIA
>
> Adrian

Don't use RDBMS for the things better solved by the operating system. Check out inotifywait and inotifywatch utilities. If you want to script it, there is a Perl module called Linux::Inotify. Inotify is a kernel module, available since the kernel 2.6.13, which means that RH 5.0 and compatible or newer versions have it. RH 5.0 has kernel 2.6.18. Very good article about Inotify is here:
http://www.ibm.com/developerworks/linux/library/l-ubuntu-inotify/index.html

-- 
Mladen Gogala
http://mgogala.freehostia.com