How to write a SQL Loader control file to load data into multiple tables

Question

I have a data file with 3 different sets of information like this below:

@@@08016995BUILD  12/15/04POSITION
"AABPX    ","76826309","M","L","     1509.4340"
----More similar Records_-------------------------
@@@08016995BUILD  12/15/04SECDESC
"AABPX    ","mf","AMERICAN AADVANTAGE BALA","NCED PLAN AHEAD         ","                        ","                        ","  14.4500","121504","   14.4500"
-----More similar Records-----------------------
@@@08016995BUILD  12/15/04CUSTOMER
"xxxxxxx","FINANCIAL SOLUTIONS      ","ACCOUNT             ","xxxxx ST               ","xx            xxxxx","                              ","000-000-0000","xxx-xxx-xxxx","xxxxx","xx","xxxxx","   ","xx","  "," "," "
          ","  14.4500","121504","   14.4500"
-----More similar Records-----------------------
end of data file

Now I want to write a control file that would push the first set of data to a position table, second set of data to a sec desc table, and 3rd set of data to a customer table. HOw can I do this?

moleboy · Accepted Answer · 2009-07-28 15:53:22Z

2

http://www.orafaq.com/wiki/SQL*Loader_FAQ#Can_one_load_data_from_multiple_files.2F_into_multiple_tables_at_once.3F

answered Jul 28, 2009 at 15:53

moleboy

8741 gold badge10 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to write a SQL Loader control file to load data into multiple tables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related