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

conversion error loading table due to character set mismatch

in Database

exported(using expdp) schema from oracle database that uses charset WE8MSWIN1252, and while import huge schema which has 1.5TB using impdp to Target where character set is AL32UTF8 , getting below error due character set mismatchs

ORA-02374: conversion error loading table "PRODDTA"."WMS_LOG_PD
ORA-12899: value too large for column XML1 (actual: 4003, maximum: 4000)

Source DB is on-prem and Oracle DB version 12c (12.1.0.1)
NLS_NCHAR_CHARACTERSET = AL16UTF16
NLS_CHARACTERSET = WE8MSWIN1252

Target DB is on DBAAS OCI and Oracle DB version 19c (19.26)
NLS_NCHAR_CHARACTERSET = AL16UTF16
NLS_CHARACTERSET = AL32UTF8

Please help

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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