资讯

精准传达 • 有效沟通

从品牌网站建设到网络营销策划,从策略到执行的一站式服务

sqlldr相关

--DROP SEQUENCE SEQ_P_ENTERHALLLEADFLOW_CODES;
CREATE  SEQUENCE SEQ_P_ENTERHALLLEADFLOW_CODES START WITH 1 CACHE 100;


CREATE OR REPLACE TRIGGER tri_1 BEFORE INSERT ON P_ENTERHALLLEADFLOW_CODES FOR EACH ROW WHEN(NEW.ID IS NULL)
BEGIN
SELECT SEQ_P_ENTERHALLLEADFLOW_CODES.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
/
sqlldr sh20000_wx/sh20000_wx log=1.log bad=1.bad discard=dis.log control=1.ctl
 
LOAD DATA
INFILE '1.text'
INFILE "2.txt"
APPEND
INTO TABLE P_ENTERHALLLEADFLOW_CODES
Fields terminated    by","
TRAILING NULLCOLS
(
ID "SEQ_P_ENTERHALLLEADFLOW_CODES.NEXTVAL",
LEAD_CODE, 
isvalid FILLER
)
 
CREATE INDEX IDX_lead_code ON P_ENTERHALLLEADFLOW_CODES(lead_code) tablespace TSH10000_WX;

sqlldr tt/tt log=1.log bad=1.bad discard=dis.log control=11.ctl

dos2unix
===========================
# crm start #####################################################################################
#
# interface
rm -f de_bst_interface.txt
cat /oradata2/share_interface/hmbst/in/97SI*.txt >de_bst_interface.txt
mv  /oradata2/share_interface/hmbst/in/97SI*.txt /oradata2/share_interface/hmbst/arch
sqlldr userid=add114/add114 control=de_bst_interface.ctl log=log/de_bst_interface_$TIME.log errors=1000 bad=de_bst_interface_$TIME.bad
#
# details
rm -f de_bst_details.txt
cat /oradata2/share_interface/hmbst/in/97SD*.txt >de_bst_details.txt
mv  /oradata2/share_interface/hmbst/in/97SD*.txt /oradata2/share_interface/hmbst/arch
sqlldr userid=add114/add114 control=de_bst_details.ctl log=log/de_bst_details_$TIME.log errors=1000 bad=de_bst_details_$TIME.bad
#
# bad
cp de_bst_interface*.bad /oradata2/share_interface/hmbst/bad
cp de_bst_interface*.bad /oradata2/share_interface/hmbst/arch
rm -f de_bst_interface*.bad
cp de_bst_details*.bad /oradata2/share_interface/hmbst/bad
cp de_bst_details*.bad /oradata2/share_interface/hmbst/arch
rm -f de_bst_details*.bad
#
# crm end #######################################################################################



网页题目:sqlldr相关
网站地址:http://www.cdkjz.cn/article/jhcscs.html
多年建站经验

多一份参考,总有益处

联系快上网,免费获得专属《策划方案》及报价

咨询相关问题或预约面谈,可以通过以下方式与我们联系

大客户专线   成都:13518219792   座机:028-86922220