Oracle External table Processing Chinese Characters

In an External table file, if the fields in the file are separated by ctrl + F, the ctrl + F separator cannot be recognized after the Chinese characters, causing an error in External table import, the solution is to add the following content when creating an external table:

Characterset 'al32utf8'

Example:

Drop table tablename

Create table tablename

(

Id

Var char2 (40 ),
Age

Int,
Name

Varchar2 (40 ),

 

)

Organization External

(

Type Oracle_Loader

Default Directory Extfile_data

Access parameters

(

Records delimited by newline

Badfile ExtFile_bad: 'tablename _ % a _ % p. bad'

Logfile Extfile_log: 'tablename _ % a _ % p. Log'

Characterset 'al32utf8'

Fields terminated by x '06'

Missing field values are null

(

Id

Char (40 ),
Age

,
Name

Char (40)

 

)

)

Location ('filename ')

)

Parallel

Reject limit Unlimited;