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 External table import problem. The solution is:
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 External table import problem. The solution is:
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;
,