RE: import

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:moucka_at_cekia.cz]
> 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: moucka_at_cekia.cz
>
> 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: John Kanagaraj
  INET: john.kanagaraj_at_hds.com

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