一、unl文件导入oracle
1、在Oracle上建表a
2、vi一个a.ctl文件，内容如下：
load data
infile ‘/home/see/nginrun/importNA/a.unl’
insert into table a
fields terminated by ‘|’
C1,
C2,
C3,
C4,
C5,
C6,
C7,
C8
)
3、sqlldr sdu/sdu control=a.ctl direct=y log=a.log
二、oracle导出unl
上传oraexporter
./oraexporter user=sdu password=sdu tns=10.166.46.230 query=”select * from a” file=a1.unl printtime