Re: IMPORTING a dump from a different system

Thanks for the reply Marin, however after a while i managed to import the database into Oracle after setting nls_lang=AMERICAN a more generic character set i think ..... it worked fine

Regards,

Gavin Dmello

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, February 28, 2002 3:18 PM

>
> ----- 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gavin D'mello
  INET: gavin_d_at_tis.co.in

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).