High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center