Recently, we have seen this error while importing application schemas from one environment to another(which are of same Platforms). the import log had this below error.
we are on 12.1.0.2.4(both environments on same version). we see below error because we have soem undefined or some characters that not able to convert while importing.. check and see if you see any text with different characters in comments that look ODD.
we are on 12.1.0.2.4(both environments on same version). we see below error because we have soem undefined or some characters that not able to convert while importing.. check and see if you see any text with different characters in comments that look ODD.
ORA-39346: data loss in character
set conversion for object DATABASE_EXPORT/SCHEMA/TABLE/COMMENT
Oracle has a patch for Bug# 21342624 ...
Note :- download the one that you need for ..because oracle has this patch for different versions..
once you aplly this patch.. 21342624. do the import again(only comments) and see what all columns with tables are reported. and try to alter those comments...
Hope this Helps.......
No comments:
Post a Comment