1.编辑控制脚本copy.ctl
options(skip=1,BINDSIZE=20971520, ROWS=10000, READSIZE=20971520, ERRORS=999999999)
load data
CHARACTERSET utf8
infile '/home/oracle/part-00000-04cf2530-87cb-4f9f-a094-5047baa3366c.csv'
append into table "CK_CREDIT_LOAD_NEW_COPY1"
fields terminated by ','
(
id,serial_number,contract_number,name,sex,educational,cart_type,card_number,document_type,identification_number,product_name,phone_number,home_number,home_adress,work_number,work_name,work_address,billing_address,name_of_contact_1,contact_of_contact_1,phone_number_of_contact_1,name_of_contact_2,contact_of_contact_2,phone_number_of_contact_2,spouse_no,other_contact_information,other_contact_phone_number,account_opening_date,account_opening_institution,bill_day,account_status,number_of_overdue_periods,credit_limit,large_amount,credit_line_overdraft_amount,non__amount_of_large_amount,amount_not_apportioned_installment,ove