本文共 618 字,大约阅读时间需要 2 分钟。
1)建立操作系统目录e:/test,准备数据文件dept.txt并置于e:/test之下 "10","ACCOUNTING","NEW YORK""20","RESEARCH","DALLAS""30","SALES","CHICAGO""40","OPERATIONS","BOSTON" CREATE directory e_test AS 'e:/test'; CREATE TABLE new_dept(deptno NUMBER(2) ,dname VARCHAR2(14) ,loc VARCHAR2(13)) organization EXTERNAL(TYPE oracle_loader DEFAULT directory e_test access PARAMETERS(records delimited BY newline badfile 'dept.bad' discardfile 'dept.dsc' logfile 'dept.log' fields terminated BY ',' optionally enclosed BY '"' missing field VALUES are NULL) location('dept.txt')); 转载地址:http://eztai.baihongyu.com/