Does the dbms_datapump.data_remap (column_function ) work after the data is inserted ?

Hi,

I am working with the dbms_datapump package. We are importing a single byte export into a multi-byte al32utf8 19c database.

As such we are getting the ORA-12899: value too large for column on some 4000 char columns. Although it is clear what causes this (we98 something to al32utf8 db causes a multiplication of bytes when encountering the 'wrong' single bytes.) i had hoped to solve this by using the dbms_datapump.data_remap (column_function ) option.

You can refer to a package/function that does something to/with your data. In that we are simply truncating the data to 991 char (to stay below the out-of-line border). That function works since we are seeing after the import that the maximum length for this column is 991 chars.