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'

 

SOLUTION:
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