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;
