sqlldr
export NLS_LANG=AMERICAN_AMERICA.AL32UTE8 export ORACLE_HOME-/oracle/product/19.3.0/db_1 /oracle/product/19.3.0/db_1/bin/sqlldr userid=test22/test22@192.168.1.100:1521/orcl direct=true control=/oradata/ctl/sys_organ.ctl log=/oradata/ctl/log/sys_organ.log bad=/oradate/ctl/bad/sys_organ.bad
OPTIONS(skip=1,rows=8000,ERRORS=50,bindsize=16777216,readsize=16777216,error=1,direct=true)
load data
CHARACTERSET AL32UTF8
infile '/oradata/20240306/sys_organ.dat'
truncate into table sys_organ
fields terminated by '|&|' optionally enclosed by '\n'
trailing nullcols
(
UUID,
M_CODE "trim(:DEP CODE"), -- 去除空格
M_NAME CHAR(2000),
..
)
file sys_organ.dat
iconv -f IOS-8859-1 -t UTF-8 sys_organ.dat > sys_organ2.dat