sqlloder脚本

os-源
-----------------------------------------------------------------------
#!/bin/bash
# User specific environment and startup programs
source /home/oracle/.bash_profile
# default retetion
if [ $# == 1 ];then
    DATE=${1}
else
    DATE=`date -d yesterday +%Y%m%d`
fi
cd  /data/script/mysql/mysql_report/
rm -rf we.csv
mysql  -uroot -ppass < /data/script/mysql/mysql_report/report.sql

#-------------ftp file from master
FTP_IP=10.25.x.x
FTP_PORT=21
FTP_USER="user"
FTP_PWD="pass"
# ftp upload function
function FTP_PRO ()
{
/usr/bin/ftp -i -n < open ${FTP_IP} ${FTP_PORT}
user ${FTP_USER} ${FTP_PWD}
binary
put wepayreport.csv
bye
EOF
}
FTP_PRO

mysql
----------------------------------------------------------------------
select *  INTO OUTFILE '/data/script/mysql/mysql_report/wepayreport.csv' FIELDS TERMINATED BY ',' FROM table;

os-目标
----------------------------------------------------------------------
#!/bin/bash
# User specific environment and startup programs
source /home/oracle/.bash_profile
# default retetion
if [ $# == 1 ];then
    DATE=${1}
else
    DATE=`date -d yesterday +%Y%m%d`
fi
cd /data/oracle/u02/wepay_email
rm -rf *.csv
#-------------ftp file from master
FTP_IP=10.25.x.x
FTP_PORT=21
FTP_USER="user"
FTP_PWD="pass"
# ftp upload function
function FTP_PRO ()
{
/usr/bin/ftp -i -n < open ${FTP_IP} ${FTP_PORT}
user ${FTP_USER} ${FTP_PWD}
binary
mget report.csv
bye
EOF
}
FTP_PRO

#--sqlloader
/data/oracle/u01/app/oracle/product/11.2.0/dbhome_1/bin/sqlldr report/pass control=report.ctl;


sqlloder
-----------------------------------------------------------------------------------
LOAD DATA
INFILE report.csv
truncate into table table_name
FIELDS TERMINATED BY "," TRAILING NULLCOLS
(
id,  
create_time  DATE 'YYYY-MM-DD HH24:MI:SS'
)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29076828/viewspace-1304845/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29076828/viewspace-1304845/