1

Topic: external table

Good afternoon. Is external table which loads CSV a file in the table. In CSV a file after headid there is a transfer of a line. Help, please, as in external table correctly to write, that headid it was loaded without transfer of a line (chr (13)).

create table WT_EX
(
lastname VARCHAR2 (256);
name1 VARCHAR2 (256);
name2 VARCHAR2 (256);
birthday VARCHAR2 (256);
p VARCHAR2 (256);
departmentid VARCHAR2 (256);
role VARCHAR2 (256);
employment VARCHAR2 (256);
dismissal VARCHAR2 (256);
fuid VARCHAR2 (256);
email VARCHAR2 (256);
headid VARCHAR2 (256)
)
organization external
(
type ORACLE_LOADER
default directory WT_FROM_DIR
access parameters
(
records DELIMITED by newline
BADFILE ' sotr_bad.bad'
LOGFILE ' sotr_log.log'
FIELDS TERMINATED BY ';'
)
location (WT_FROM_DIR:'blablabla 27.01.2018.csv ')
)
reject limit 10;

2

Re: external table

-2;
Was on big_smile thanks!