创建外部表ｅｘｔｅｒｎａｌ ｔａｂｌｅ

--创建目录

CREATE OR REPLACE DIRECTORY file_dir AS 'D:\ORA_DATA\bfile_dir';

--快速创建

CREATE TABLE dept_external (
   deptno     NUMBER(6),
   dname      VARCHAR2(20),
   loc        VARCHAR2(25)
)
ORGANIZATION EXTERNAL
(TYPE ORACLE_LOADER
DEFAULT DIRECTORY file_dir
FIELDS TERMINATED BY ','  OPTIONALLY ENCLOSED BY '"'
 )
LOCATION('I.csv'))

--完整创建
CREATE TABLE dept_external (
   deptno     NUMBER(6),
   dname      VARCHAR2(20),
   loc        VARCHAR2(25)
)
ORGANIZATION EXTERNAL
(TYPE ORACLE_LOADER
DEFAULT DIRECTORY file_dir
ACCESS PARAMETERS(RECORDS DELIMITED BY NEWLINE
  BADFILE 'ulcase1.bad'
  DISCARDFILE 'ulcase1.dis'
  LOGFILE 'ulcase1.log'
  SKIP 0 --跳过的行数
FIELDS TERMINATED BY ','  OPTIONALLY ENCLOSED BY '"'
  (
   deptno     INTEGER EXTERNAL(6),
   dname      CHAR(20),
   loc        CHAR(25)
  )
)
LOCATION('I.csv'))