从windows下的sqlserver导出的文本文件到linux下,执行oracle sqlldr 报错
log文件
SQL*Loader-500: Unable to open file (****.dat)
SQL*Loader-555: unrecognized processing option
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
log文件
SQL*Loader-500: Unable to open file (****.dat)
SQL*Loader-555: unrecognized processing option
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
cd /d "%~dp0"
你应该导出的是loader的吧。。这样会有两个文件,你是只拷过去一个??
OPTIONS(rows=1000,readsize=20489599,ERRORS=99999,parallel=true)
LOAD DATA
CHARACTERSET ZHS16GBKINFILE '*****.dat' "STR X'3C3E'"
INFILE '*******.dat' "str X'3C3E'"