Tuesday, 30 July 2019

ORA-39346: data loss in character set conversion for object

ERROR:


Processing object type SCHEMA_EXPORT/TABLE/COMMENT
ORA-39346: data loss in character set conversion for object SCHEMA_EXPORT/TABLE/COMMENTProcessing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
ORA-39346: data loss in character set conversion for object SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
ORA-39346: data loss in character set conversion for object SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY

CAUSES:

Issue is occurring during the data migration from third party system to oracle database on Solaris server.

SOLUTION:

Apply this Oracle Patch 21342624 DATA LOSS DUE TO CHARACTER SET NOT SHOWING CORRECT SET OF OBJECTS DURING IMPORT

No comments:

Post a Comment

Migration of extract and pump process from 11g to 19c in golden gate

 In this example, we are going to migrated golden gate from 11g to 19c. As part of migration, we need to perform the below steps. Step 1: Pr...