oracle 导入txt
没有Oraclehoume的情况下，执行下环境变量文件
sqlldr userid= DM/DM control = /home/oracle/libc/load.ctl
load data
infile ‘/home/oracle/libc/data.txt‘
insert into table tmp_dm_user_total_month
fields terminated by ‘\t‘
(
acct_date ,
provincecode ,
citycode ,
product_id ,
total_user_sendmail ,
total_sendmail ,
web_user_sendmail_num ,
pc_user_sendmail_num ,
pc_user_recmail_num ,
wap_user_sendmail_num ,
mobile_user_sendmail_num ,
web_sendmail_num ,
pc_sendmail_num ,
pc_recmail_num ,
wap_sendmail_num ,
mobile_sendmail_num ,
totoal_user_m ,
totoal_user_lm ,
active_user_m ,
active_user_lm ,
web_active_user_m ,
web_active_user_lm ,
pc_active_user_m ,
pc_active_user_lm ,
wap_active_user_m ,
wap_active_user_lm ,
mobile_active_user_m ,
mobile_active_user_lm ,
sso_active_user_m ,
sso_active_user_lm ,
register_users ,
unregister_users
)
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
