Skip to Main Content

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!

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

ANURAG DBA INDIANov 23 2016 — edited Feb 14 2017

Hello,

I  got the error during import Schema dump .Already applied patch in 12c : 21342624 .Provide valuable inputs

Source:

Database version : 11.2.0.3

OS : Linux

Target :

Database Version : 12.1.0.2

OS : Linux

Error:

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

FYI

Oracle Interim Patch Installer version 12.1.0.1.3

Copyright (c) 2016, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc

OPatch version    : 12.1.0.1.3

OUI version       : 12.1.0.2.0

Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2016-11-18_12-24-43PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2016-11-18_12-24-43PM.txt

--------------------------------------------------------------------------------

Installed Top-level Products (1):

Oracle Database 12c                                                  12.1.0.2.0

There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch  23568976     : applied on Fri Nov 18 12:13:40 EST 2016

Unique Patch ID:  20290678

   Created on 10 Jun 2016, 09:06:12 hrs PST8PDT

   Bugs fixed:

     20677396, 22243719

Patch  21342624     : applied on Thu Nov 17 18:57:39 EST 2016

Unique Patch ID:  19231863

   Created on 8 Sep 2015, 11:15:05 hrs PST8PDT

   Bugs fixed:

     21342624

--------------------------------------------------------------------------------

OPatch succeeded.

Regards,

Anurag Kumar

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 14 2017
Added on Nov 23 2016
9 comments
11,318 views