June 19th, 2012 
rishi 
0 
0 
0 
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'
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.
0 0 0 
Posted in Uncategorized 
Tags: 