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

What is text size limit in Data Integration File

Accepted answer

Summary: Error in log file says text size limit is 2000 but Oracle Doc 2457185.1 says it is 4000. If I take the full text (3,781 characters), I can paste it in a form completely but if I try to load the same data, I get an error that the maximum is 2000?

EPMFDM-140274:Message - ORA-12899: value too large for column "EPMPRODPHXVM511"."TDATASEG_T"."DATA" (actual: 2001, maximum: 2000)

If that is the case does anyone have any ideas how to get all the data loaded? I tried copying the row of data and splitting it across two rows and running Replace/Merge and I also tried Append/Merge but I only got the first row. I thought maybe it would update to include the second row but it didn't.

Howdy, Stranger!

Log In

To view full details, sign in.


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