import dmp that has been exported from AR8MSWIN1256 into utf8
hi,
i have a problem, i have a .dmp file exported from oracle database that uses charset AR8MSWIN1256 and i have a new server with oracle database that uses charset utf8, now im facing a problem when importing that .dmp into the new server, im guessing its because the charset ,im getting this error while importing :
ORA-02374: conversion error loading table "schema_name"."TableName"
ORA-12899: value too large for column col (actual: 112, maximum: 100)
my question is it because the different charsets or something else either way what can i do to fix such problem where i can import a .dmp thats from database uses AR8MSWIN1256 into database that uses utf8
0