Database Utilities (MOSC)

MOSC Banner

impdp errors Ora 02374, 12899, 02372

edited Nov 29, 2010 1:04AM in Database Utilities (MOSC) 4 commentsAnswered
Expdp from 10gR2 and impdp into 11gR2. Both hosts are running 2003R2 x64 std. The old 10g install was 32bit. the 11h install is 64bit.

10g db was setup using  WEISO8859P1. 11g db is AL32UTF8

On import of the data we get numerous:

ORA-02374: conversion error loading table "ARADMIN"."T176"
ORA-12899: value too large for column C536870913 (actual: 4000, maximum: 4000)
ORA-02372: data for row: C536870913 : 'The following reports of NAK embarrasment were fou

I know in the past developers where changing nls_length_semanics from byte to char a few times.  Both the 10g and 11g db are currently set to byte.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center