Oracle 数据导入到新库出现中文乱码的原因：旧库和新库的字符集不一致引起的。1、查询字符集的值select parameter,value from nls_database_parameters where parameter='NLS_CHARACTERSET';2、更改字符集sql> SHUTDOWN IMMEDIATE;sql> STARTUP MOUNT;sql> ALTER SESSION SET sql_TRACE=TRUE;sql> ALTER SYSTEM ENABLE RESTRICTED SESSION;sql> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;sql> ALTER SYSTEM SET AQ_TM_PROCESSES=0;sql> ALTER DATABASE OPEN;sql> ALTER DATABASE CHARACTER SET ZHS16GBK;sql> alter database character set internal_use ZHS16GBK;sql> SHUTDOWN IMMEDIATE;sql> STARTUP;sql> execute sys.dbms_Metadata_util.load_stylesheets;