马上要做生产库的数据迁移了。自己先做试验练习练习。今天先来做简单的
db2
create table t1(c1 int,c2 int,c3 int)
insert into t1 values(1,2,3)
export "d:\test.del" of del messages "d:\test.mesg" select * from t1
oracle
create table t1(c1 int,c2 int,c3 int)
编写 c.ctl
load data
infile 'd:\test.del'
into table t1
fields terminated by ',' optionally enclosed by '"'
(
c1,
c2,
c3
)
在命令行运行
sqlldr scott/tiger control="d:\test.txt" log="d:log"
成功。
今天是最简单的了。明天开始加大难度
阅读(1014) | 评论(0) | 转发(0) |