Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Schedule a Windows batch file to load datafile to table using sqlldr?

162178Nov 5 2012 — edited Nov 6 2012

Hi,

I want to schedule a batch file job that contains "sqlldr user/passwd@...." etc.

The oracle is installed at a different location than where the data file is located on C: drive.

For example:
sqlldr is at C:\oraclexe\app\oracle\product\11.2.0\server\bin\sqlldr and the
control file and data file are located at
C:\GenOn_projects\employee_data_merge\test.ctl
C:\GenOn_projects\employee_data_merge\test.txt

I started the batch file in command window.. It opens up a window with title which contains the sqlldr, and it appears to wait a few seconds and finsihes but does not seem to load the data.

iIn the code below \\1KHChilds-L2.services.reinternal.com in the code below is the my PC name. ^ is line continuation.

start "\\1KHChilds-L2.services.reinternal.com\oraclexe\app\oracle\product\11.2.0\server\bin\sqldr userid=sbhat/password@tedw ^
control=\\1KHChilds-L2.services.reinternal.com\employee_data_merge\test.ctl ^
data=test.txt"

Any help is appreciated.

Suresh Bhat