ORA-39346 error While Importing ReIM Application Schema
(Doc ID 2665779.1)
Last updated on MAY 03, 2023
Applies to:Oracle Retail Merchandising System - Version 16.0.1 to 16.0.2 [Release 16.0]
Oracle Retail Invoice Matching - Version 16.0.1 to 16.0.3 [Release 16.0]
Information in this document applies to any platform.
When trying to import ReIM application schema, below errors are seen in import log even though character set of source and destination database are the same:
ORA-39346: data loss in character set conversion for object SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
ORA-39346: data loss in character set conversion for object SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
ORA-39346: data loss in character set conversion for object SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
And the issue exists even after applying Database <Patch 21342624>: DATA LOSS DUE TO CHARACTER SET NOT SHOWING CORRECT SET OF OBJECTS DURING IMPORT. The issue applicable for RMS schema as well.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document