Hi Roland,
try this:
1) 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
