You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

import dmp that has been exported from AR8MSWIN1256 into utf8

Received Response


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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!