loadrec

来自「一本介绍oracle的书籍」· 代码 · 共 15 行

USER_PASSWD=dbuser/oracle

sqlplus -s $USER_PASSWD <<EOF
truncate table user_info;
exit
EOF

TABLE=user_info

#conventional path
#sqlldr $USER_PASSWD control=ctl/${TABLE}.ctl log=ctl/${TABLE}.log rows=10000 bindsize=8192000

#direct path
sqlldr $USER_PASSWD control=ctl/${TABLE}.ctl log=ctl/${TABLE}.log direct=true