Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: export from 8.1.7, import to 8.1.5

Re: export from 8.1.7, import to 8.1.5

From: Jack <nospam_at_nospam.com>
Date: Mon, 12 May 2003 05:09:49 GMT
Message-ID: <x0Gva.6184$6q6.868659@news2.telusplanet.net>


The rule of thumb:

  1. Export the data with the Export utility of the lowest database version involved. 2. Import the data with the Import utility of the target database.

So try exp and imp using 815 client only.

"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?
>
> Thanx in advance,
> -maz
>
> --
> ---------------------Use e-mail. It saves trees----------------------
> Maz Mohammadi Senior Member of the Technical Staff
> mailto:maz_at_savvion.com (415)378-9241
> http://www.savvion.com Savvion Inc.
>
> "Programming today is a race between software engineers striving to
> build bigger and better idiot-proof programs, and the Universe trying
> to produce bigger and better idiots. So far , the Universe is winning."
> -- Rich Cook
>
>
Received on Mon May 12 2003 - 00:09:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US