外部表创建简单例子

例子1：

create table KFC_TMP12

(
  owner VARCHAR2(50),
  segname varchar2(80)
)
organization external
(
  type ORACLE_LOADER
  default directory DUMP_AIKI
  access parameters
  (
    records delimited by newline
    FIELDS TERMINATED BY X'09'   --TAB（EXCEL)分格数据
  )
  location ('20121114.txt')
)

reject limit UNLIMITED;

----------------------------------------------------

例子2

create table KFC_TMP12030
(
  OWNER   VARCHAR2(50),
  SEGNAME VARCHAR2(80),
  tablespace_name varchar2(30),
  diff_mg number
)
organization external
(
  type ORACLE_LOADER
  default directory DUMP_AIKI
  access parameters
  (
    records delimited by newline
    FIELDS TERMINATED BY X'09'
    missing field values are null                           --允许将列为空的行插入
( owner,segname,tablespace_name,diff_mg)
  )
  location (DUMP_AIKI:'new2.txt')
)
reject limit UNLIMITED;