Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Datatype CLOB: lossy conversion when migrating from WE8ISO8859P1 to AL32UTF8

vivalavidaOct 22 2013 — edited Oct 22 2013


We have data of an application in a database of release 9.2.0.8 (characterset WE8ISO8859P1).

The data shall now be migrated into a database of release 11.2.0.3 (characterset AL32UTF8).

When executing the CSSCAN utiltity on the target database (9.2.0.8) I get the following result:

Table : MASTERCONTENT
Column: INFO
Type  : CLOB
Number of Exceptions         : 116      
Max Post Conversion Data Size: 1489532  

ROWID              Exception Type      Size Cell Data(first 30 bytes)    
------------------ ------------------ ----- ------------------------------
AAA4jBAAKAAACRcAAA lossy conversion 
AAA4jBAAKAAACRcAAB lossy conversion 
AAA4jBAAKAAAvNqAAA lossy conversion 
AAA4jBAAKAABg0nAAC lossy conversion 
AAA4jBAAKAABg0nAAE lossy conversion

...

From my understanding CLOB objects can store up to (4 gigabytes -1) * (the value of the CHUNK parameter of LOB storage)

of character data. Or is the problem that the characters of some rows can't get converted into AL32UTF8?

Currently I do not understand why "lossy conversion" will happen...

Any help will be appreciated!

Rgds

Jan

This post has been answered by Sergiusz Wolicki-Oracle on Oct 22 2013
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 19 2013
Added on Oct 22 2013
1 comment
1,859 views