Problem in UTF8 migration from monolingual characterset

Hi all,

When the oracle database of monolingual character set was exported and imported in a UTF8 data base

The following error log is found for some tables having BLOB attribute or string type:

User : SUDB

Table : ZBINDB

Column: ZBINDATA(BLOB type)

Type : LONG

Number of Exceptions : 25

Max Post Conversion Data Size: 23499423

ROWID Exception Type Size Cell Data(first 30 bytes)

• ------------------ -----

  ---

AAAA5tABpAAAIy+AAA lossy conversion nEventLog

AAAA5tABpAAAJ/MAAA lossy conversion nEventLog

User : CORPDB

Table : DSSDmtr
Column: T2TEXTFR

Type : VARCHAR2(32)

Number of Exceptions : 578

Max Post Conversion Data Size: 34

ROWID Exception Type Size Cell Data(first 30 bytes)

• ------------------ -----

  ---

AAABkIAARAAAUk7AAI exceed column size 33 COUDE 90° LR DN 1"1/2 BW SCH. AAABkIAARAAAUkDAAA exceed column size 33 BUTEE SKF N° 51107 DE 35X 52

Can anyone suggest me how to recover those rows in UTF8 database?

All the best ,update ur contacts with me.

G.Venkatesh

Infosys Technologies Ltd,Mysore

0821 4071625

venkatme198410_at_yahoomail.co.in

venkatesh_g01_at_infosys.com Received on Tue Feb 14 2006 - 07:10:27 CST