Chinese data garbled by sqlldr

Chinese data garbled by sqlldr

When data is installed on the test machine, all Chinese fields are changed ???????, Character Set Problems

Change UPDATE sys. props $ set value $ = 'we8iso8859p1 'where name like 'nls %' and value $ = 'zhs16gbk'; commit; the SQL * Loader-704 error is reported when sqlldr collects data: internal error: ulmtsyn: OCIStmtExecute (tabhp) [6552] ORA-06552: PL/SQL: Compilation unit analysis terminatedORA-06553: PLS-553: character set name is not recognized. After checking the information, you can find that you still need to set the database to RESTRICTED mode when setting the character set. After performing the following operations, sqlldr collection is normal> startup mount; ORACLE instance started. total System Global Area 76619308 bytes Fixed Size 454188 bytes Variable Size 58720256 bytes Database Buffers 16777216 bytes Redo Buffers 667648 bytes Database mounted. SQL> alter session set SQL _TRACE = TRUE; Session altered. SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION; System altered. SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 0; System altered. SQL> ALTER SYSTEM SET AQ_TM_PROCESSES = 0; System altered. SQL> ALTER DATABASE OPEN; Database altered. SQL> set linesize 120 SQL> ALTER DATABASE CHARACTER SET ZHS16GBK; ORA-12712: new character set must be a superset of old character setRROR at line 1:

> Alter database character set INTERNAL_USE zhs16gbk;

> Alter session set SQL _TRACE = FALSE;