In this forum you can share stuff related to Oracle 11g, 10g, 9i.
-
sonukhan
- Posts: 6
- Joined: Thu Jun 14, 2007 12:06 pm
- Location: India
Post
by sonukhan »
I have 10 flat files in single folder ,so by using one control file how we transfer all 10 files data in single table.
-
siva sankar
- Posts: 130
- Joined: Sun Mar 11, 2007 1:47 am
- Location: India
Post
by siva sankar »
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.
-
antojoen
- Posts: 6
- Joined: Fri Nov 23, 2007 5:59 pm
- Location: United Arab Emirates
Post
by antojoen »
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.
Users browsing this forum: No registered users and 4 guests