Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> impdp facing ORA-39346, use expdp 11g impdp to 12c face ORA-39346
Jerry_1122
post Aug 22 2017, 02:12 AM
Post #1


Newbie
*

Group: Members
Posts: 3
Joined: 22-August 17
Member No.: 52,129



HI ,

I am using expdp export from 11G rhel54 , and impdp to 12c rhel72,
and reported
ORA-39346: data loss in character set conversion for object TABLE_STATISTICS:"schema_name "."table_name"
Processing object type SCHEMA_EXPORT/JOB

checked CHARACTERSET and both source and target same as below......

PARAMETER VALUE
------------------------------ ---------------
NLS_CHARACTERSET AL32UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16

how to fix this reported , or this not impact transfer and not impact real data

thanks all...
Go to the top of the page
 
+Quote Post
burleson
post Aug 22 2017, 07:42 AM
Post #2


Advanced Member
***

Group: Members
Posts: 13,532
Joined: 26-January 04
Member No.: 13



Hi Jerry, and welcome to the forum!

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

Cause: Oracle Data Pump import converted a metadata object from the export database character set into the target database character set prior to processing the object. Some characters could not be converted to the target database character set and so the default replacement character was used.

Action: No specific user action is required. This type of data loss can occur if the target database character set is not a superset of the export databases character set.

This is a well known bug and there is a note on the Ora-39346 error on MOSC:

Http://support.oracle.com

Apply patch 21342624 and you should be fine!

You can also workaround this by adding comments.

Good luck!


--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Jerry_1122
post Aug 23 2017, 11:29 PM
Post #3


Newbie
*

Group: Members
Posts: 3
Joined: 22-August 17
Member No.: 52,129



QUOTE (burleson @ Aug 22 2017, 08:42 PM) *
Hi Jerry, and welcome to the forum!

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

Cause: Oracle Data Pump import converted a metadata object from the export database character set into the target database character set prior to processing the object. Some characters could not be converted to the target database character set and so the default replacement character was used.

Action: No specific user action is required. This type of data loss can occur if the target database character set is not a superset of the export databases character set.

This is a well known bug and there is a note on the Ora-39346 error on MOSC:

Http://support.oracle.com

Apply patch 21342624 and you should be fine!

You can also workaround this by adding comments.

Good luck!


Thanks so much for your comment,
well, my target db character is the same as source db, so no need to take action , and no impact on real data, right ?

Regards

Go to the top of the page
 
+Quote Post
burleson
post Aug 24 2017, 01:54 PM
Post #4


Advanced Member
***

Group: Members
Posts: 13,532
Joined: 26-January 04
Member No.: 13



Hi Jerry,

Yes, that is my understanding, but double check on MOSC and apply the patch!

Good luck!


--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Jerry_1122
post Aug 24 2017, 09:25 PM
Post #5


Newbie
*

Group: Members
Posts: 3
Joined: 22-August 17
Member No.: 52,129



QUOTE (burleson @ Aug 25 2017, 02:54 AM) *
Hi Jerry,

Yes, that is my understanding, but double check on MOSC and apply the patch!

Good luck!


thanks so much for your suggestion, i will check it .

good day
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd September 2017 - 10:08 PM