Database Utilities (MOSC)

MOSC Banner

Problems with character set in Export-Import database

edited Nov 19, 2009 8:24AM in Database Utilities (MOSC) 1 commentAnswered
 Hi my name is Marcello.

I have got a database oracle 8.1.7 with character set AMERICAN_AMERICA.US7ASCII.

I exported the database with:

export NLS_LANG=AMERICAN_AMERICA.US7ASCII

exp effenerg/xxxxx@aegg file=exp_effenerg.dmp FULL=y log=zexp.log

On another machine, i have got a database oracle 10.2.0.4 with AMERICAN_AMERICA.WE8MSWIN1252

I imported the 8i database in this 10g database with:

export NLS_LANG=AMERICAN_AMERICA.US7ASCII

imp system/yyyy@aegg file=exp_effenerg.dmp fromuser=effenerg touser=effenerg log=imp.log

After import, i noted that all the characters "à", "ò", "ù", "è", "ì" was importing with character "?"

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