ERPstuff - Oracle EBS Community

I have 10 flat files in single folder ,so by using one control file how we transfer all 10 files data in single table.

Hi,

Please try this one...

LOAD DATA
INFILE ?C:\FIRST.DAT?
INFILE ?C:\SECOND.DAT?
INSERT INTO TABLE FIXED_EMP
FIELDES TERMINATED BY ?,?
(EMPNO, ENAME, DEPTNO)

if any queries please let me know.

Hi,

Use a loop to execute this.

Take a count *.DAT files and execute the .CTL files that many times. Dont hardcode the *.DAT file name into the control files. That should be dynamic.