On Wed, 2004-08-25 at 20:43, Ken Naim wrote: > Well this is not that novel but might be worth including we use external > tables as our "staging" tables for our data warehouse; It saves us from > duplicating space as we can manipulate the data directly from the flat file > and it allows us to do it all in one pass rather than two. > Appreciate the reply. You are however doing exactly what external tables were designed for. I'm trying to avoid that. :) Jared ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------