Use the bulk loader to perform "within-database" inserts

From: Dino Hsu <dino1_at_ms1.hinet.net>
Date: 13 May 2002 20:14:03 -0700
Message-ID: <c48a8333.0205131914.1adda26a@posting.google.com>

Dear all,

In Kimbal's DW Lifecycle book pp. 622-623, he tells to use the bulk loader to perform "within-database" inserts: QueryProgram &username &password <extract_query.sql | \ LoaderProgram load_script.ctl &username &password

In my Oracle 8.1.7 for Windows 2K case, it's: sqlplus username/password_at_db @extract_query.sql sqlldr username/password_at_db data=extract_query.txt control=load_sth.ctl
because sqlldr.exe doesn't take input data from stdin, so a data file has to be created in the first query with spool, this writing might add additional time to Kimbal's original idea.

Generally speaking, do you think bulk loader is the best way to do this? Anyone comes with a better idea? Please also reply to <dino1_at_ms1.hinet.net>, thanks a lot.

Regards,
Dino Received on Mon May 13 2002 - 22:14:03 CDT