Shell Programming and Scripting

Sorry about that. Register for a free account at Oracle's Technet.

Here is a simple control file to use:

Code:

# pir.ctl
LOAD DATA 
INFILE 'pir.dat' 
BADFILE 'pir.bad'
DISCARDFILE 'pir.dsc'

INTO TABLE "PIR_UD"
INSERT
(gid,time)

Put your data in the ".dat" file as comman delimited.

Code:

GID1,Value1
GID2,Value2

Invoke sqlldr as follows:

Code:

sqlldr control=pir.ctl data=pir.dat

Oracle should prompt you for your username and password.

Don't let this fool you though. If you increase your data's complexity, you are going to increase the complexity of the control file as well.

Good luck,

Thomas

Hi , I tried that piece of code it gave me the following error:

awk: record `2005/02/21 16:56:45....' too long
record number 1

cheers,
Jo

Hi guys, i'm being a bt dumn here but will be great if you can help!

I'm writing this script(named as Jo.sh), now i'm wondering if i need to include the ctl file within the unix script or should the ctl file be called from within the script file. Here are the details:

Should the script look like this:

#jo.sh (this is the script file on my unix machine)
nice grep sent pac.txt |nice grep 'log ins'|nice grep spot_markup|cut -c12-23>jo.txt
nice grep sent pac.txt |nice grep 'log ins'|nice grep spot_markup|cut -c107-113>jo1.txt

paste jo.txt jo1.txt>pir.dat

# pir.ctl

sqlplus -s asasas/asasa@asas.com << ++ > /dev/null

LOAD DATA
INFILE 'pir.dat'
BADFILE 'pir.bad'
DISCARDFILE 'pir.dsc'

INTO TABLE "PIRSUP_GID_ORDERS"
INSERT
(GID_ID,DEAL_TIME)


cheers,
Jo