Re: Importing from a client with a different charachter set

assuming that '8DEC is a subset of '8859P1

set your NLS_LANG environment variable ( or register setting ) on the export side and then export. Set the same thing on your import side, '8859P1, prior to your export.

e.g. on the export DB: NLS_LANG=AMERICAN_AMERICA.WE8DEC;export NLS_LANG

     do the export

        on the import side: NLS_LANG=AMERICAN_AMERICA.WE8DEC;export NLS_LANG
     do the import

hope this helps

--
Jim Gregory
Principal Consultant for Keane, Inc.
Currently assigned to NCR, Dayton, OH

Opinions are my own and do not reflect those
of my employer or clients
"Nicolas Bronke" <newsgroup_at_trinity.de> wrote in message
news:9ee2d9$991$05$1_at_news.t-online.com...


> I am trying to import a dumpfile, which is created on a database with the

> character set WE8DEC. But my Database has WE8ISO8859P1. Therefore I get an

> error message ORA 2248 Invalid option for alter session

>

> Sofar so good. But how can I import this file? Is there any chance?

>

> regards

>

> Nicolas

>

>