| calling multiple .dat files in 1 .ctl file [message #69307] |
Thu, 06 December 2001 16:59  |
thaufek
Messages: 2
Registered: December 2001
|
Junior Member |
|
|
can i call multiple data files in 1 control file i tried this but it gives error somebody pls help me?
LOAD DATA
INFILE 'C:dataadmin.expbootlis113.unl'
BADFILE 'C:loaderadmin.bad'
APPEND INTO TABLE BOOTLIST
FIELDS TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"'
( RMSI,DSCANI,TESTSETDRV,SCL,SNIDER,X25SERVER,API )
LOAD DATA
INFILE 'C:dataadmin.expdb_upda103.unl'
INTO TABLE DB_UPDATES
FIELDS TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"'
( SCRIPT, DATA )
Thanks
----------------------------------------------------------------------
|
|
|
|
| Re: calling multiple .dat files in 1 .ctl file [message #69309 is a reply to message #69307] |
Fri, 07 December 2001 03:53  |
Suresh Vemulapalli
Messages: 624
Registered: August 2000
|
Senior Member |
|
|
one control file should have only one datafile.
if you want to run at one shot..write different control files for each datafile and try calling from batch file.
load.bat
sqlldr uid/pwd ldr1.ctl
sqlldr uid/pwd ldr2.ctl
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
