SQL query to identify the row in the table using the data for row reference
Hi ,
We are migrating database from 11g Western European character set to 19c American Character set .
As expected, we are seeing errors with column length for 2 records in initial test run. But we have to migrate to American character set, and project team wants to check the missing records information in the table import.
Do we have any SQL query to identify the row in the table using the data for row reference "0X'5042A3333033393936303331303035'"?
ORA-12899: value too large for column TOKEN (actual: 16, maximum: 15)
ORA-02372: data for row: TOKEN : 0X'5042A3333033393936303331303035'
(LENGTH(TOKEN)) COUNT(*)
------------------- ----------
14 9162295
15 3382955
Thanks,
Kiran