SQL*Loader - How can I add data into a table where the table name is defined in Unicode characters,

 Hi All

In our globalized .NET application it's possible for the end-user to create table names with Unicode characters, e.g. the enduser can create a table with Chinese characters. We then have a functionality which wants to add data into this table by calling the SQL*Loader (Release 11.2.0.1.0).

1. We call this Batch file:

set nls_numeric_characters=.,
sqlldr USERID=Username/Password,CONTROL=ControlFile.ctl,LOG=LogFile.log,SKIP_UNUSABLE_INDEXES=TRUE,BINDSIZE=10485760,READSIZE=10485760,ROWS=10000

2. Our Control file:

LOAD DATA
CHARACTERSET UTF16
INFILE DATAFILE_1.dat
BADFILE BADFILE_1.bad
DISCARDFILE DISCARD_1.dsc
APPEND INTO TABLE 区域的拓扑名
FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"'