我想把同样的文件,一次倒入两个表中,两个表的结构完全一样,
该test.ctl内容如下:
Load Data
INFILE 'test.txt'
Append
Into Table test1
Trailing Nullcols
(
name terminated by ":",
hight terminated by ":",
)
Into Table test2
Trailing Nullcols
(
name terminated by ":",
hight terminated by ":",
)可是最后执行sqlldr control=test.ctl direct=true时候,能把数据倒入第一个表,第2个表的值是空的,但也不报错,请问如何修改该格式呀?
该test.ctl内容如下:
Load Data
INFILE 'test.txt'
Append
Into Table test1
Trailing Nullcols
(
name terminated by ":",
hight terminated by ":",
)
Into Table test2
Trailing Nullcols
(
name terminated by ":",
hight terminated by ":",
)可是最后执行sqlldr control=test.ctl direct=true时候,能把数据倒入第一个表,第2个表的值是空的,但也不报错,请问如何修改该格式呀?
Load Data
INFILE 'test.txt'
Append
Into Table test1
Trailing Nullcols
(
name position(1:10),
hight position(15:25)
)
Into Table test2
Trailing Nullcols
(
name position(1:10),
hight position(15:25)
)