Re: EXPORT / IMPORT Problem

From: Trifon Anguelov <trifona_at_pacbell.net>
Date: Wed, 17 Oct 2001 05:11:34 GMT
Message-ID: <aq8z7.2927$PI.628005025@newssvr13.news.prodigy.com>

"Wade Chy" <wchy65_at_hotmail.com> wrote in message news:36df3e33.0110161837.457a56a5_at_posting.google.com...
> Hi All
> I am trying to import a dump file to a 8.1.5 database. I did the
> export from another server running 8.1.7. When I run the imp command I
> get an error msg.:
>
> 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 setup the charset parameter to WE8ISO8859P1. But it still does not
> work. Please help.
>
> Also is possible to import dump file into Oracle8 exported from
> Oracle8i?
>
> Thank you in advance.

Wade,

If you have IP connection to 8.1.7 server, then run the export from 8.1.5 against 8.1.7 database through database link and the import using 8.1.5 exp binary.

Hope that helps.

Trifon Anguelov
Senior Oracle DBA

http://www.dbaclick.com Received on Wed Oct 17 2001 - 00:11:34 CDT