Database Utilities (MOSC)

MOSC Banner

ORA-02374 (IMPORT DATAPUMP)

edited Aug 9, 2021 12:03PM in Database Utilities (MOSC) 11 commentsAnswered ✓

I'm getting ORA-02374 (conversion error loading table) but the length of the column (varchar2(4000 CHAR)) is sufficient. A few rows cannot be inserted.

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

ORA-12899: value too large for column FORMULA (actual: 4000, maximum: 4000)

ORA-02372: data for row: FORMULA : 'bankID=..., clientID=..., columnNames=[IC'

I do not understand this behaviour, has anybody an idea or recommendations for me?

Additional Information:

Patchlevel: Source-DB-Version: 19.9

Patchlevel: Target-DB-Version: Database Release Update : 19.11.0.0.210420 (32545013)

Column_name= FORMULA

Both Datatypes are VARCHAR2(4000 CHAR)

Error is thrown only when length(FORMULA) = 4000

Tagged:

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center