SQL & PL/SQL

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

FIELDS TERMINATED BY "µ" OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS

NelsonMendesMar 20 2020 — edited Mar 20 2020

Hi all,

Good morning.

I'm having one issue whit a specific ctl file, I can't understand why it's not splitting the columns so I'm having the entire row in the first column.

It seems that sql loader is not able to parse the micro sign as a delimiter.

Can you please help me?

SQL*Loader: Release 12.2.0.1.0

OPTIONS(SKIP=1, ERRORS=0, MULTITHREADING=TRUE, DIRECT=TRUE, SILENT=(ALL))

LOAD DATA

CHARACTERSET UTF8

INFILE '/orabatch/ftpcpl/in/OPPORTUNITIES.csv'

BADFILE '/orabatch/ftpcpl/in/OPPORTUNITIES.bad'

DISCARDFILE '/orabatch/ftpcpl/in/OPPORTUNITIES.dsc'

REPLACE

INTO TABLE OPPORTUNITIES

FIELDS TERMINATED BY "µ" OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS

(

HPTL CHAR,

NAME CHAR,

STAGENAME CHAR,

OPPORTUNITYOWNER CHAR,

CLOSEDATE CHAR,

STRATEGY CHAR,

RECORDTYPEID CHAR,

CAMPAIGNKEY CHAR,

EXCLUDECLOSEAUTO CHAR,

CENTRALIZEDCAMPAIGN CHAR,

LISTTYPE CHAR

)

Both files, ctl and csv, were encoded with UTF-8, LINUX format.

Thanks,

This post has been answered by Paulzip on Mar 20 2020

Jump to Answer

Added on Mar 20 2020

8 comments

425 views