ORA-02374 ORA-12899 ORA-02372

ORA-02374: conversion error loading table "table_06182012"."PROGRAMS"

ORA-12899: value too large for column DESCRIPTION1 (actual: 837, maximum: 440)

ORA-02372: data for row: DESCRIPTION1 : 'Actiethriller (AU/US). Zakenman Russell Franklin i'


Error occured when importing table dump from one DB server to another.

this type of errore occurs when you import dump to database  with a single-byte character set (WE8MSWIN1252)

and exported dump was from database  with multi-byte character set (AL32UTF8).

i.e. both databases are running in different character sets.

Cross check the same from nls_database_parameters view.

So to resolve this issue, import DB to same character set as exported from.


You can skip to the end and leave a response. Pinging is currently not allowed.

Leave a Reply