The test machine is loaded into the data found in the text field all become???????, the preliminary judgement of the character set problem
change update sys.props$ set VALUE$= ' We8iso8859p1 ' where name like ' nls% ' and value$= ' ZHS16GBK '; commit; Sqlldr sql*loader-704:internal Error:ulmtsyn:OCIStmtExecute (tabhp) when the data is collected /sql:compilation Unit Analysis Terminatedora-06553:pls-553:character set name was not recognized found that the original change character set also needs to be Set the database set to restricted mode and other operations, after doing the following operations, Sqlldr collect normal >startup mount; oracle instance started. Total System Global area 76619308 bytes fixed size 454188 bytes variable size 58720256 Bytes databas e buffers 16777216 Bytes redo buffers 667648 bytes database mounted. sql> ALTER SESSION SET SQL_T Race=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 the old character setRror at line 1:
>alter DATABASE Character Set Internal_use ZHS16GBK;
>alter SESSION SET Sql_trace=false;
SQLLDR acquisition of Chinese data garbled problem