先用perl在windows上把文件格式转换 或者FTP的时候ASCII模式
D:\external>perl -p -e 's/$/\r/' <alert_mydb.log> t.txt
drop table alert_ex
create table alert_ex ( text varchar2(400) )
organization external (
type oracle_loader
default directory dir_ex
access parameters (
records delimited by newline
nobadfile
nodiscardfile
nologfile
)
location('t.txt')
)
reject limit unlimited
查看
select * from alert_ex