Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL Loader on Linux need help writing a script

SQL Loader on Linux need help writing a script

From: Jennifer <Jennifer_at_DAG[DELETEME>
Date: Wed, 09 Jan 2002 20:40:07 GMT
Message-ID: <HU1%7.14929$8e.759706@news>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US