Shulou(Shulou.com)06/01 Report--

Import data Times error the following error, this is because the original database is GBK, each Chinese character is two bytes, but the new database is AL32UTF8, each Chinese character is three bytes, resulting in exceeding the length.

ORA-12899: value too large for column ORG_NAME (actual: 145, maximum: 128)

Resolve:

First record the values of the JOB_QUEUE_PROCESSES and AQ_TM_PROCESSES parameters, and then modify them so that you can change them back. On my side are 1000 and 1.

Operation steps

SHUTDOWN IMMEDIATE;STARTUP MOUNT;ALTER SYSTEM ENABLE RESTRICTED SESSION;ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;ALTER SYSTEM SET AQ_TM_PROCESSES=0;ALTER DATABASE OPEN;ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK;ALTER SYSTEM SET JOB_QUEUE_PROCESSES=1000;ALTER SYSTEM SET AQ_TM_PROCESSES=1

Check step

Set linesize 1000select * from nls_database_parameters

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.