Database Utilities (MOSC)

MOSC Banner

how to export import from WE8ISO8859P9 to WE8ISO8859P1

edited Sep 12, 2018 1:40PM in Database Utilities (MOSC) 5 commentsAnswered ✓

Hi,

How can I export and import schemas from a DB that has NLS_CHARACTERSET = WE8ISO8859P9 , to another DB that has NLS_CHARACTERSET = WE8ISO8859P1 ?

Origin:

SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;

WE8ISO8859P9

Destination:

SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;

WE8ISO8859P1

My Version of DB is Oracle EE 11.2.0.4: origin and destination.

Thanks for your help.

David

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center