如何写一个SQL Loader控制文件将数据加载到多个表
问题描述:
我有3套不同的信息的数据文件中像下面这样:如何写一个SQL Loader控制文件将数据加载到多个表
@@@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
现在我想写这将推动一个控制文件第一组数据到位置表,第二组数据到秒表,第三组数据到客户表。我怎样才能做到这一点?
答
http://www.orafaq.com/wiki/SQL * Loader_FAQ#Can_one_load_data_from_multiple_files.2F_into_multiple_tables_at_once.3F