Oracle-L: Re: IMPORTING a dump from a different system

From: Marin Dimitrov <marin.dimitrov_at_sirma.bg>
Date: Thu, 28 Feb 2002 01:48:25 -0800
Message-ID: <F001.0041ABD4.20020228014825@fatcity.com>

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, February 28, 2002 08:58

> Hi All,
> I just got a dump file from Oracle 8i on an AIX system and
> was trying to import it in Oracle 8i on a Suse Linux System, but got the
> error 'IMP-00016: required character set conversion (type 46 to 871) not
> supported'. Can you help me out ? I know it has to do with the NLS_LANG
> environment variable, but if I change the character set to the one used by
> the AIX system i get an error while logging in to 'imp'. Can anyone help
me
> out as to what value should NLS_lang contain ?
>

what are the source and database character sets?

871 seems to be some of the UTF charsets, but which one is 46?

note that changing NLS_LANG may not solve your problems - you can avoid unnecessary conversions by properly setting NLS_LANG but if u have incompatible character set on the two servers, it won't help you

Marin

"...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. "

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Marin Dimitrov
  INET: marin.dimitrov_at_sirma.bg

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Feb 28 2002 - 03:48:25 CST