Greenplum同步到Oracle
浏览数：39 /
时间：2015年06月12日
开发提出需要从Greenplum同步到Oracle的解决方案，写了个脚本用于定时调度处理。
#!/bin/sh
#copy_gp_2_ora.sh
if [ $# -ne 1 ]; then
echo "Usage: sh $0 tablename"
exit 1
fi
TABLENAME=$1
psql -h <host> -U <user> <db><<EOF
\timing off
set client_encoding=‘gb18030‘;
\copy $TABLENAME to ‘/home/oracle/$TABLENAME.txt‘ csv
\q
EOF
echo "load data
infile ‘$TABLENAME.txt‘ discardfile ‘$TABLENAME.dis‘
append
into table $TABLENAME
fields terminated by ‘,‘
optionally enclosed by ‘\"‘
(id)">"$TABLENAME.ctl"
sqlldr system/000000 control="$TABLENAME.ctl" log="$TABLENAME.log"
-EOF-
#!/bin/sh
#copy_gp_2_ora.sh
if [ $# -ne 1 ]; then
echo "Usage: sh $0 tablename"
exit 1
fi
TABLENAME=$1
psql -h <host> -U <user> <db><<EOF
\timing off
set client_encoding=‘gb18030‘;
\copy $TABLENAME to ‘/home/oracle/$TABLENAME.txt‘ csv
\q
EOF
echo "load data
infile ‘$TABLENAME.txt‘ discardfile ‘$TABLENAME.dis‘
append
into table $TABLENAME
fields terminated by ‘,‘
optionally enclosed by ‘\"‘
(id)">"$TABLENAME.ctl"
sqlldr system/000000 control="$TABLENAME.ctl" log="$TABLENAME.log"
-EOF-
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
