solving the problem of importing garbled sqlldr Processing process: 1, the local establishment of control files load datainfile ' d:\TMP_KAITOUSHUJU.csv ' into the table Tmp_kaitoushujufields terminated by ', ' (trade _co,full_name,customs_code,co_class,valid_date,rg_date,addr_co,busi_type,contac_co,tel_co,law_man,law_man_tel, Co_type,break_law_time1,break_law_time2,inspect_time,cop_modify_date) 2, under Windows use the following command to perform the import Sqlldr userid=test/[ Email protected] Control=d:/tmp_kaitoushuju.ctl log=d:/sqlload.log 3, import error, hint partial column empty, check the syntax after correcting the control file as follows load Datainfile ' d:\TMP_KAITOUSHUJU.csv ' into table tmp_kaitoushujufields terminated by ', ' trailing nullcols -- Treats all columns that are not at the specified location in the record as null values (Trade_co,full_name,customs_code,co_class,valid_date,rg_date,addr_co,busi_type,contac_co, tel_co,law_man,law_man_tel,co_type,break_law_time1,break_law_time2,inspect_time,cop_modify_date) 4, import successfully, But open a look garbled through the select * from V$nls_parameters; View Nls_characterset as Al32utf8, and my machine is GBK, so this machine through the DOS window for the following settings: Set Nls_lang=american_america. Al32utf8 also change the control file as follows: Load dataCHARACTERSET Al32utf8 (in the CTL file with the character set, the same as the Oracle character set, select * from V$nls_parameters t where T.paramete R = ' Nls_characterset '; )InFile ' d:\TMP_KAITOUSHUJU.csv ' into table tmp_kaitoushujufields terminated by ', ' trailing nullcols--treats all columns that are not at the specified location in the record as Null value (Trade_co,full_name,customs_code,co_class,valid_date,rg_date,addr_co,busi_type,contac_co,tel_co,law_man,law_ Man_tel,co_type,break_law_time1,break_law_time2,inspect_time,cop_modify_date)
Solving the problem of importing garbled SQLLDR