Database Utilities (MOSC)

MOSC Banner

expdp from WE8ISO8859P15 and impdp to AL32UTF8

edited Aug 16, 2017 9:21AM in Database Utilities (MOSC) 1 commentAnswered

Hi Team,

We have the source database with 11.2.0.4 character-set  WE8ISO8859P15 and the target database 12.2 with character-set AL32UTF8.

We tried to do a export from source to target, but due to characterset mismatch, we got the below issue.

Import: Release 12.2.0.1.0 - Production on Mon Aug 7 17:57:36 2017

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

;;;

Connected to: Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production

..........

..........

import done in AL32UTF8 character set and AL16UTF16 NCHAR character set

export done in WE8ISO8859P15 character set and AL16UTF16 NCHAR character set

Warning: possible data loss in character set conversions

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center