oracle 匯入txt

標籤：檔案   cti   on   c   ad   sql   oracle   file   table   

沒有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
)

oracle 匯入txt