This discussion is archived
2 Replies Latest reply: Oct 15, 2012 5:22 AM by 936749 RSS

impdp error number of bytes exceeds limit of varchar2

936749 Newbie
Currently Being Moderated
Hi,
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?
Regards
933746

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points