Re: export from 8.1.7, import to 8.1.5

"maz" <maz_at_savvion.com> wrote in message news:3EBF5308.1FE9F318_at_savvion.com...
> hi all,
>
> I am trying to export from a 8.1.7 installation on Linux and import into
> 8.1.5 on Win2K. The export finished perfectly, with the Character set
> of US7ASCII. I did not have the NLS_LANG env param set in my shell.
> Now when I try to import the dmp file on the 8.1.5 installation on Win2K
> I get the error on imp:
>
> 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
>
> would anyone please point me to a place where I can pass this hurdle?

I'm afraid this one is ansked and answered on a monotonously regular basis. When you export/import across versions, the *export* has to be done using the *lower* version of the export executable.

You therefore need to do the export from your Windows machine, so that the 8.1.5 executable is invoked. Use tnsnames to direct the connection to the 8.1.7 database on the linux machine. That will give you an 8.1.5-compatible dump file, and 8.1.5 import should be able to handle it without a problem.

Regards
HJR Received on Mon May 12 2003 - 16:26:06 CDT