参考博客:https://blog.csdn.net/city6789/article/details/44616947
oracle的字符集为AL32UTF8,汉字会占用3个字符;所以需要改为ZHS16GBK。
执行下列sql语句,即可解决问题:
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL> ALTER DATABASE OPEN;
SQL> ALTER DATABASE CHARACTER SET ZHS16GBK;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;