Re: External tables - Determine changed source file

google_at_sauerzapf.de wrote:
> Is there a way to determine from PL/SQL whether the source file of an
> external table has changed ?
> I need this as i sometimes override some source files with a new
> delivery.
> A check of the creation date and/or file size will be "good enough"

With respect to Oracle one can safely state: What isn't documented, also doesn't exist.

So the answer is obviously : NO.
You could easily write a script and trigger Oracle to process the file, couldn't you?
Or do you like maintaining messes?

-- 
Sybrand Bakker
Senior Oracle DBA