以下为控制文件:c:\cont.ctlload datainfile 'c:\loader.txt'into table tname(m1 char terminated by ",",m2 char terminated by ",")以下时数据文件:c:\loader.txtaaa,bbbcccc,ddddeeeee,fffff在执行前先建表:create table TNAME( M1 VARCHAR2(100), M2 VARCHAR2(100))在cmd下执行以下语句:sqlldr ifsapp/misdt@test control=c:\cont.ctl data=c:\loader.txt
一共有 0 条评论