ORA-02374: conversion error loading table , ORA-12899: value too large for column

During the import i faced the following error –

ORA-02374: conversion error loading table “CONSOLIDATION”.”CLIENT_OPPORTUNITY”
ORA-12899: value too large for column DESCRIPTION (actual: 259, maximum: 255)
ORA-02372: data for row: DESCRIPTION : ‘$1,000,000 Equipment Term Loan capped at $250,000

 

After analysing i found that in Production Database “NLS_CHARACTERSET” value was “WE8MSWIN1252” and in the UAT Database “NLS_CHARACTERSET” value was “AL32UTF8”

To find out the NLS_CHARACTERSET value use the below query

sql> select * from NLS_DATABASE_PARAMETERS;

So i changed the “NLS_CHARACTERSET” value to “WE8MSWIN1252” in the UAT database as bellow –

sql> shutdown

sql> startup restrict;

sql> ALTER DATABASE CHARACTER SET INTERNAL_USE WE8MSWIN1252;

sql> shutdown;

sql> startup;

 

It worked for me 🙂