我想把同样的文件,一次倒入两个表中,两个表的结构完全一样,
该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个表的值是空的,但也不报错,请问如何修改该格式呀?
解决方案 »
- 招聘Oracle开发维护人员
- oracle 表contents实用多少查看
- 執行Oracle store Procedure時報錯:Object variable or With block variable not set
- 存储过程中以数组作为参数
- 又遇到个问题,请大家再帮帮忙哦
- oracle备份
- ORACLE 8.1.6 目录服务访问怎么配置???
- oracle9i for windows2000安装后,用sqlplus internal/oracle接上oracle,不知道用户名和密码?
- Oracle中布尔型数据处理问题 600里加急
- 高手请进
- 请问各位仁兄一个经验方面的问题!
- 包、游标和动态sql的结合使用->SQL命令未正确结束
没见过,学习....