DROP DIRECTORY DIR_ANALYSIS_LOG;
CREATE DIRECTORY DIR_ANALYSIS_LOG AS '/home/matchkf/bin';
DROP TABLE tb_analysis_log;
CREATE TABLE tb_analysis_log
(
v_head VARCHAR2(100),n_count NUMBER,v_flag1 VARCHAR2(10),v_event VARCHAR2(100),
v_flag2 VARCHAR2(10),n_totaltime NUMBER,n_eventtime NUMBER
)
ORGANIZATION EXTERNAL
(
TYPE oracle_loader
DEFAULT DIRECTORY DIR_ANALYSIS_LOG
ACCESS PARAMETERS
(
records delimited BY newline characterset zhs16gbk
badfile 'log.bad'
LOGFILE 'log.log'
readsize 1048576
fields terminated BY ',' optionally enclosed BY '"' ldrtrim
REJECT ROWS WITH ALL NULL fields
)
LOCATION
(
'log.txt'
)
) REJECT LIMIT UNLIMITED;