Oto, You will need to set the operating system environment variable NLS_LANG to the one that was used for the export. (Just go back to the source system and type in 'echo $NLS_LANG' and set the same value). This is *only* in case you have NOT used the DIRECT=Y option - if you exported using the direct method, you will need to export normal again and use this bypass. This is because the Oracle kernel needs to be able to preserve the character set across export/import, and DIRECT=Y avoids this translation buffer during export.
John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Kill your killer-commute! Listen to great commercial-free christian music 24x7 (details at www.klove.com) ** The opinions and statements above are entirely my own and not those of my employer or clients ** > -----Original Message----- > From: Moucka otakar [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 23, 2001 5:40 AM > To: Multiple recipients of list ORACLE-L > Subject: import > > > Hello listers, > > I have problem with character encoding during import using imp. > > > > Error code is ......> IMP-00016: > > > required character set conversion (type 1 to 871) not supported . > > > > My question is : What is syntax for import with settings > charset ? > Database charaset is UTF8. > Thanx Oto > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Moucka otakar > 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: John Kanagaraj 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).
