Re: import problem

Luca wrote:

> I'm creating a export schema with Oracle8i Release 8.1.7.0.0 - Production
> JServer Release 8.1.7.0.0 - Production when I make import:
>
> Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.6.0.0 - Production
>
> Export file created by EXPORT:V08.01.07 via conventional path
> import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character
> set
> IMP-00069: Could not convert to environment national character set's handle
> IMP-00000: Import terminated unsuccessfully

I see two problems here:

[Quoted] [Quoted] 1st: You export a 8.1.7 database and try to import it in a 8.1.6 database. To [Quoted] solve this problem, use the exp utility from your 8.1.6 to do the export.

[Quoted] 2nd: You are using a character set which is not convertiable to WE8ISO8859P1. [Quoted] Set your NLS_LANG variable to a subset or equal to WE8ISO8859P1.

Regards,

Knut Received on Mon May 06 2002 - 14:58:31 CEST