Database Utilities (MOSC)

MOSC Banner

IMPDP fails from 10gR2 to 11gR2

edited Feb 22, 2012 11:41AM in Database Utilities (MOSC) 3 comments
Hi,
source Oracle version : 10.2.0.1 (Enterprise Edition)
target Oracle Version   : 11.2.0.1 (standard Edition )

Hi,


Here when we try to import daump file in to 11.2.0.1  database from 10.2.0.1  database export dumpfile we got the below error.

ORA-02374: conversion error loading table "sample"."NSF"
ORA-12899: value too large for column COMMENTS (actual: 209, maximum: 150)
ORA-02372: data for row: COMMENTS : 0X'BF03504750BFBF4E0315BF7C2721BFBFBF100800BF0EBF32BF'
 
ORA-02374: conversion error loading table "sample"."NSF"
ORA-12899: value too large for column COMMENTS (actual: 208, maximum: 150)
ORA-02372: data for row: COMMENTS : 0X'6E4B0BBF1BBFBFBF12BFBF25561467BF5ABFBF32BFBF784224'
 
Can any one please help me how to resolve this problem.

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