AW: Unix-script

From: <PRIBILLA.Michael_at_EU.DRAGOCO.COM>
Date: Thu, 30 Aug 2001 08:35:51 -0700
Message-ID: <F001.0037D2B7.20010830084148@fatcity.com>

Hi Roland,

try this:

shell script

#!/usr/bin/ksh

# ora_load.sh
# load data to db using sql loader

. /etc/profile
. $HOME/.profile

cd /home/oracle/load

# set Oracle specific environmental variables here
export NLS_NUMERIC_CHARACTERS=".,"
export ORACLE_SID=TEST

$ORACLE_HOME/bin/sqlldr <user>/<password> control=ora_bla.ctl

2) control file ora_bla.ctl for sql loader

---------------------------------------------
Controlfile for sql loader
--------------------------------------------- LOAD DATA INFILE "/home/oracle/load/load.sqlldr" BADFILE "/home/oracle/load/load.bad" APPEND

INTO TABLE ORA_LOAD
Fields terminated by "|"
(
<field specification goes here>
)

3) entry in crontab
00 4 * * 1-6 /home/oracle/load/ora_load.sh >/dev/null 2>&1 # Index Report

Hope this helps.

Regards,
Michael

-----Ursprüngliche Nachricht-----
Von: Roland.Skoldblom_at_ica.se [mailto:Roland.Skoldblom_at_ica.se] Gesendet am: Donnerstag, 30. August 2001 17:16 An: Multiple recipients of list ORACLE-L Betreff: Unix-script

Hallo

Can anyone give me an example on how to write a unix script which schedules the run run of a sqlloader script from unix server into the database. I mean I could easily get the file tmanually o be imported if i use the ftp command, but how do i do if I want that to be scheduled?

Roland S

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Roland.Skoldblom_at_ica.se


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Aug 30 2001 - 10:35:51 CDT