如题,现在这样导入是可以的,如果把col2 的POSITION改为fields terminated by " "就不行了;请教如何把同一个文本中的数据导入到不同的2个表中。谢谢
LOAD DATAINFILE 'filename.txt'appendINTO TABLE table1WHEN col1!= ' '
fields terminated by " "
TRAILING NULLCOLS
(col1,col2)INTO TABLE table2WHEN col2!= ' '
(col1 POSITION(1:11) CHAR,
col2 POSITION(12:18) CHAR)
LOAD DATAINFILE 'filename.txt'appendINTO TABLE table1WHEN col1!= ' '
fields terminated by " "
TRAILING NULLCOLS
(col1,col2)INTO TABLE table2WHEN col2!= ' '
(col1 POSITION(1:11) CHAR,
col2 POSITION(12:18) CHAR)
empno number,
empname char(20),
birthday date)
organization external
(type oracle_loader
default directory mydir
access parameters
(records delimited by newline
badfile 'bad_oldemp'
logfile 'log_oldemp'
fields terminated by ','
missing field values are null
(empno, empname,
birthday char date_format date mask "yyyy.mm.dd",
commission_pct, deptno))
location ('emp1.txt'))
parallel 5
reject limit 200;上面红色字体要求创建一个名为mydir的directory对象,并将其read,write权限授予本用户.
绿色字体是你的文件名,其他字段根据表结构定义.
谢谢 5楼的回答,不知道在只改ctl文件的情况下能不能实现,将一个文本文件导入到表结构相同的2张表中?