Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to solve Import impdp error : value too large for column ?

vmatOct 2 2015 — edited Oct 15 2015

Hello,

As an occasional user of Oracle DB, I encounter some issues that I'm not able to fend off, like this error, happening when I import (with impdp) my last Oracle .dmp file with Oracle DB 11.2.0.2.0 :

ORA-02374: conversion error loading table "QUALIGRAM"."TBLGRAPHS"

ORA-12899: value too large for column GREF (actual: 52, maximum: 50)

ORA-02372: data for row: GREF : 0X'33203520532052465320436F6E7472BF6C6520647520706169'

I have this error like 30 times for 2 different tables.

Is this problem due to the characters encoding? How can I operate to correct this error?

Thanks you for your help, and sorry for my bad english.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 12 2015

Added on Oct 2 2015

#database-key-features, #export-import-sql-loader-external-tables

16 comments

9,613 views