SQL Loader
19.11For load data file to your database with otomatis on unix
MAIL=/usr/mail/${LOGNAME:?}
ORACLE_BASE=/orac/app; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/; export ORACLE_HOME
PATH=.:$ORACLE_HOME/bin:/opt/bin:/bin:/usr/bin;export PATH
NDMAPICFG=/d_dir/ndm/cfg/cliapi/ndmapi.cfg
export NDMAPICFG
-------------login n path to oracle--------------------------
cd /archive/jancuk/karepmu_loader/input
for fname in ls * ;do
-------------deklarasi file to move in your database---------
sqlldr cps/cps2@CPC control=/ftpdata1/app/ins_file_jancuk_success.ctl
data=/archive/karepmu/file_loader/input/$fname bad=/
archive/karepmu/file_loader/bad/$fname.bad discard=/archive/karepmu/file_loader/discard/$fname.dsc
log=/archive/karepmu
/jancuk_loader/log/$fname.log
------------proses loader file get in database oracle-----------
note : BLUE for variabel file to get on proses
RED for usr/pass login to database
on file target must syncrone with table format on DB
you can use crontab to for schedular ontime proses
0 komentar