第1 步
create directory ex_temp as 'd:/oracle/data'
第2步
grant read,write on directory ex_temp to jstdba
第3步
create table jstdba.temp(name varchar2(200),age number ,qt number )
organization external(type oracle_loader default directory ex_temp location('temp.txt'))