Unanswered: impor data from files and other tables at the same time?
I need to import data to tables in database 8i from different data sources, both flat files and other tables at the same time. How can I achive this goal. I need to do so is because the data of the file don't keep everything I need to import. Some of columns' data must to retrieve from other tables.
Originally posted by rollingpig
you may import the flag file into another table
and then mix the columns with the existing table
Thanks for your reply.
So What I need to do is put SQL Loader in the part of the PL/SQL script. In the script, I need to import data from flag file into tmp table with SQL LOADER and then mix data from other tables and tmp table?