Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: External tables - Determine changed source file

Re: External tables - Determine changed source file

From: sybrandb <sybrandb_at_gmail.com>
Date: 19 Dec 2006 02:56:58 -0800
Message-ID: <1166525818.727581.3080@f1g2000cwa.googlegroups.com>

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
Received on Tue Dec 19 2006 - 04:56:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US