2 Replies Latest reply on Oct 15, 2012 12:22 PM by 936749

    impdp error number of bytes exceeds limit of varchar2

      I have a problem migration data from one database with western Europe character set to a new database with UTF-8 charter set. I know that this has to do with some characters using more then one byte in UTF character database. But as I have one column varchar2 is configured with 4000 byte as limit and imp reports error as some rows exceeds 4000 and actual requirement is 4009 byte which is not possible as limit of varchar2 is 4000 byte.
      I need to identify the rows that exceed 4000 byte.

      Changing datatype is not an option.

      Anyone have any ideas on how to identify the rows that exceeds 4000 bytes or anyone have a query that makes it possible to query existing environment with all rows above 3980 byte in this one column?