Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> SQL Loader on Linux need help writing a script
I was given the task to load a delimeted text files into oracle. I choose
to use SQL Loader, created a control file for each text file and then
combined the commands in a batch file that I execute. The batch file looks
like this:
::Importing data to tables
d:\oracle\bin\sqlldr scott/tiger_at_database
control=e:\Navigator\studentinfo.ctl
d:\oracle\bin\sqlldr scott/tiger_at_database
control=e:\Navigator\studentcourse.ctl
d:\oracle\bin\sqlldr scott/tiger_at_database
control=e:\Navigator\studentregistration.ctl
This works great except that now I find out O/S is linux base and not
Windows and my .bat file won't work and I need to write a linux script
instead of
a .bat file. I know nothing about unix and was wondering if any body would
send me one so I can see what it would need to look like.
thanks
jennifer_champagne_at_hotmail.com
Received on Wed Jan 09 2002 - 14:40:07 CST
![]() |
![]() |