My Oracle Support Banner

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.

Symptoms

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.

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.