Xref: alice comp.databases.oracle.server:36867
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!diablo.theplanet.net!news.sol.co.uk!news-reader1.sol.co.uk!not-for-mail
From: Uge@VaxMan.prestel.co.uk
Newsgroups: comp.databases.oracle.server
Subject: Re: EXP/IMP WE8ISO8859P1/US7ASCII issues
Date: Sat, 02 Jan 1999 02:05:31 GMT
Organization: Scotland-On-Line
Lines: 31
Message-ID: <368d7356.39039207@news.prestel.co.uk>
References: <76ill3$2fj$1@mango.singnet.com.sg>
Reply-To: Uge@VaxMan.prestel.co.uk
X-Newsreader: Forte Free Agent 1.11/16.235

WE8ISO8859P1 is a superset of US7ASCII (as its characters are storred
in 8 bits rather than 7) hence to move to 7 bit some conversion would
be necessary. Obviously (I hope) Oracle can't do this.  Hence you need
to create a new db on your Unix machine remembering to use the
WE8ISO8859P1 charset.  Then EXP/IMP and Bob's your uncle.

Aside: do NOT use direct path EXP - the IMP takes about 15 times as
long.

Eugene (Oracle Certified dba looking for job on NT or VMS).
===========================================
"Sanjay Hans" <sanhans@mbox5.singnet.com.sg> 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
> WE8ISO8859P1 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.
> 
> 
> 
>