I'm missing the first two characters of each line in my External Table. Also, it doesn't appear to recognize '\t' as a field delimiter. (could be caused by first)
I'm unsure if I'm missing something or if this is a bug
23.3 FREE - Virtual Box
create table test_data (
data_line varchar2(32767)
)
organization external (
TYPE ORACLE_LOADER
default directory data_dir
ACCESS PARAMETERS (
records delimited by DETECTED newline
byteordermark nocheck
STRING SIZES ARE IN CHARACTERS
BADFILE 'et.bad'
LOGFILE 'et.log'
FIELDS TERMINATED BY '\t'
(
data_line varchar(32767)
)
)
location ('hist.txt')
) reject limit unlimited
;