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!

import dump from Oracle 12.2 to Oracle 19: ORA-39346:data loss in character set conversion COMMENT:

User_W9DA3Dec 21 2022 — edited Dec 21 2022

When i import a data dump using the impdp utility i get the following error: ORA-39346:data loss in character set conversion for object of type COMMENT:
character set parameters are set correctly in DB:
charset = AL32UTF8
ncharset = AL16UTF16
I also explicitly set NLS_LANG env var to AL32UTF8
I used grep on the dump file and it shows the correct character sets.
The command i use to import:

impdp <connectstring> directory=dumpdir dumpfile=fumpfile logfile=logfile.log 
 REMAP_TABLESPACE=src:dest query=somequery 
version="12.2.0"

Why do i get the error? And what can i do about it? Thanks

Added on Dec 21 2022

#database, #database-key-features, #export-import-sql-loader-external-tables, #import

2 comments

1,687 views