SQL_Loader 固定格式加载数据

1、创建需要加载数据的表

create table student(
	stuno number(4),
	stuname varchar2(20),
	sex varchar2(4),
	old number(4)
);

2、制作一份文本数据

vi student.txt

1001,东方,男,30
1002,开心,女,25
1003,jack,男,23
1004,rose,女,20

3、编辑控制文件

vi student.ctl

load data 
infile '/home/oracle/oradata2/bak/loader/student.txt' 
replace into table student
fields terminated by ',' 
(stuno,stuname,sex,old)

4、加载数据

sqlldr test/test2021 control=/home/oracle/oradata2/bak/loader/student.ctl log=/home/oracle/oradata2/bak/loader/stu.log