echo off
del *.ctl
for /R %%i in (*.dat) do (
echo.%%~fnxi文件处理中...
echo.LOAD DATA>>%%~ni.ctl
echo.INFILE '%%~nxi'>>%%~ni.ctl
echo.INTO TABLE user_info>>%%~ni.ctl
echo.APPEND>>%%~ni.ctl
echo.FIELDS TERMINATED BY '\t'>>%%~ni.ctl
echo.TRAILING NULLCOLS>>%%~ni.ctl
echo.^(>>%%~ni.ctl
echo.USERID CHAR^(55^),>>%%~ni.ctl
echo.USERNICK FILLER,>>%%~ni.ctl
echo.USERSN ,>>%%~ni.ctl
echo.USERGENDER CHAR^(5^),>>%%~ni.ctl
echo.EXP ,>>%%~ni.ctl
echo."LEVEL" ,>>%%~ni.ctl
echo.SERVERNUM ,>>%%~ni.ctl
echo.TYPE CHAR^(8^),>>%%~ni.ctl
echo.IP CHAR^(15^),>>%%~ni.ctl
echo.TIME DATE 'yyyy-mm-dd hh24:mi:ss',>>%%~ni.ctl
echo.ZONE CONSTANT %%~ni>>%%~ni.ctl
echo.^)>>%%~ni.ctl
sqlldr test/test@test control=%%~ni.ctl skip=1 direct=true
)
del *.ctl
for /R %%i in (*.dat) do (
echo.%%~fnxi文件处理中...
echo.LOAD DATA>>%%~ni.ctl
echo.INFILE '%%~nxi'>>%%~ni.ctl
echo.INTO TABLE user_info>>%%~ni.ctl
echo.APPEND>>%%~ni.ctl
echo.FIELDS TERMINATED BY '\t'>>%%~ni.ctl
echo.TRAILING NULLCOLS>>%%~ni.ctl
echo.^(>>%%~ni.ctl
echo.USERID CHAR^(55^),>>%%~ni.ctl
echo.USERNICK FILLER,>>%%~ni.ctl
echo.USERSN ,>>%%~ni.ctl
echo.USERGENDER CHAR^(5^),>>%%~ni.ctl
echo.EXP ,>>%%~ni.ctl
echo."LEVEL" ,>>%%~ni.ctl
echo.SERVERNUM ,>>%%~ni.ctl
echo.TYPE CHAR^(8^),>>%%~ni.ctl
echo.IP CHAR^(15^),>>%%~ni.ctl
echo.TIME DATE 'yyyy-mm-dd hh24:mi:ss',>>%%~ni.ctl
echo.ZONE CONSTANT %%~ni>>%%~ni.ctl
echo.^)>>%%~ni.ctl
sqlldr test/test@test control=%%~ni.ctl skip=1 direct=true
)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23590362/viewspace-630921/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23590362/viewspace-630921/