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" <[EMAIL PROTECTED]> Sent: Thursday, February 28, 2002 3:18 PM > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
