Skip to Main Content

Oracle Database Free

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

External Table problem

Mike KutzNov 7 2023

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
;
This post has been answered by gsalem-Oracle on Nov 8 2023
Jump to Answer
Comments
Post Details
Added on Nov 7 2023
1 comment
454 views