|
-
Crontab tbl_load.sh script at whatever schedule you wanted.
<font face=courier>
::::::::::::::
tbl_ldgrload.sh
::::::::::::::
#!/bin/csh -f
#
echo "Starting ctlipt $0 on `date`."
setenv ORACLE_SID xyzz
setenv ORAENV_ASK NO
source /usr/bin/coraenv
#
echo sqlldr control=l_budl parfile=ldirp.par
sqlldr control='/data2/xyzz/ctl/l_budl' log='/data2/xyzz/log/l_budl.log' parfile
=ldirp.par
#
echo sqlldr control=l_clprj parfile=lconv.par
sqlldr control='/data2/xyzz/ctl/l_clprj' log='/data2/xyzz/log/l_clsprj.log' parfile=ldirp.par
#
echo sqlldr control=l_fdled parfile=ldirp.par
sqlldr control='/data2/xyzz/ctl/l_fdled' log='/data2/xyzz/log/l_fdled.log' parfile=ldirp.par
#
echo "Script $0 on `date` has finished."
#End of file.
::::::::::::::
lcnvp.par
::::::::::::::
userid = xyzz/*****
rows = 2000
discardmax = 10
errors = 100
direct = false
silent = (discards)
::::::::::::::
ldirp.par
::::::::::::::
userid = xyzz/*****
rows = 2000
discardmax = 10
errors = 100
direct = true
silent = (discards)
</font>
Reddy,Sam
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|