SQLLOADER5 (Import from multiple data files to the same table)

Importing from multiple data files to the same table is simple, just specify the path to multiple data files in the infile parameter.
Data File 1:test1.txt
1111ALLE salesman
2222WARDSALESMAN
Data File 2:test2.txt
2222jone1 Smanager
3333jone2 Smanager
Data File 3:test3.txt
4444jone3 Smanager
5555jone4 Smanager

Control file: Testsqlldr2.ctl

LOAD'D:\oracletest\test1.txt'D:\oracletest\ Test2.txt 'D:\oracletest\test3.txt'REPLACE   into TABLE   by whitespacetraling nulcols (empno,ename,job)

To perform an import:

D:\oracletest>Sqlldr Scott/Tiger@orclControl=D:\oracletest\testSqlLdr2.ctlSQL*Loader:release11.2.0.1.0 -Production onSunday November -  -: the: -  theCopyright (c)1982, the, Oracleand/orits affiliates. Allrights reserved. Reach the submission point-Logical Record Count2Reach submission Point-Logical Record Count3Reach submission Point-Logical Record Count4Reach submission Point-Logical Record Count5Reach submission Point-Logical Record Count6

To view the results of the import:

Sql> Select *  fromEMP2; EMPNO ename JOB MGR hiredate SAL COMM DEPTNO---------- ---------- --------- ---------- -------------- ---------- ---------- ----------3333JONE2 Smanager4444JONE3 Smanager5555JONE4 Smanager1111ALLE salesman2222WARD salesman2222JONE1 Smanager has selected 6 rows. 

SQLLOADER5 (Import from multiple data files to the same table)