Oracle外部表的使用

CREATE DIRECTORY tmpdir1 AS '/export/home/oracle/ctltest';

create table basechannelvisittab_tmp( 
  USER_    VARCHAR2(128),
  IP       NUMBER(12),
  TIME_    DATE,
  CHANNEL  VARCHAR2(128),
  COUNT_   NUMBER(15),
  VERS     VARCHAR2(32),
  PART_VAL INTEGER
) 

ORGANIZATION EXTERNAL (
TYPE oracle_loader
DEFAULT DIRECTORY tmpdir1
ACCESS PARAMETERS (
records delimited by newline
LOGFILE 'result.log'
BADFILE 'result.bad'
FIELDS 
terminated by "," 
MISSING FIELD VALUES ARE NULL 
(
  USER_ ,
  IP ,
  TIME_ Date 'yyyy-mm-dd hh24:mi:ss',
  CHANNEL ,
  COUNT_ ,
  VERS ,
  PART_VAL
)
)
LOCATION ('data.txt')
)
PARALLEL 4 REJECT LIMIT UNLIMITED;