Re: EXP/IMP WE8ISO8859P1/US7ASCII issues

Hi Sanjay,

There is a different and better option: recreate the Unix database with the WE8ISO8859P1 characterset. US7ASCII is a 7-bit characterset and WE8ISO8859P1 8-bit. You will always loose information when converting 8-bit to 7-bit, which is probably the reason why it is disallowed or doesn't work with import. Make sure you have NLS installed on the Unix box though (this is not installed using the default install).
Some people have explained earlier in this newsgroup it is possible to update the table sys.prop$ to change the characterset. While this method seems to work, it is definitely unsupported by Oracle.

Hth and best wishes,

Sybrand Bakker, Oracle DBA

Sanjay Hans wrote:

> I have a oracle 7.3 database on Unix which was created with US7ASCII
> character set and a Oracle 7.3 database on NT 4.0 which was created with
> character set. We used this character sets because on Unix OS
> US7ASCCII is the default character set and on Windows NT WE8ISO8859P1 is the
> default character set.
> The problem which I am facing is, I can take export backup from Oracle 7.3
> (US7ASCII character set) on Unix and import it on Oracle 7.3 (WE8ISO8859P1
> character set ) on NT 4.0 But I am not able to do the other way, i.e. take
> export backup from Oracle 7.3 (WE8ISO8859P1 character set ) on NT 4.0 and
> import it on Oracle 7.3 (US7ASCII character set) on Unix. Should I create
> Oracle database on NT 4.0 with US7ASCII character set?
>
> Would appreciate your help/suggestions.
>
> Thanks in advance.

Received on Fri Jan 01 1999 - 12:57:47 CST