Home » RDBMS Server » Server Utilities » export from 8.1.6 and import into 8.1.7
export from 8.1.6 and import into 8.1.7 [message #69175] Thu, 15 November 2001 14:00 Go to next message
Tim Sawyer
Messages: 1
Registered: November 2001
Junior Member
I am exporting from a database which is version 8.1.7 and I am trying to import the data into a database which is version 8.1.6. I am getting the following error:

import done in US7ASCII character set and US7ASCII NCHAR character set
IMP-00069: Could not convert to environment national character set's handle
IMP-00000: Import terminated unsuccessfully

Both databases are US7ASCII character set.

Has anyone received a similar error?

----------------------------------------------------------------------
Re: export from 8.1.6 and import into 8.1.7 [message #69176 is a reply to message #69175] Thu, 15 November 2001 21:15 Go to previous messageGo to next message
steffi disque
Messages: 3
Registered: November 2001
Junior Member
Hi,
Yes, I do. With a little difference. (import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR set). Both databases are done in WE8ISO8859P1. So I think, it is exactly the same problem. Has anybody an idea to solve this problem???

----------------------------------------------------------------------
Re: export from 8.1.6 and import into 8.1.7 [message #69187 is a reply to message #69176] Mon, 19 November 2001 09:03 Go to previous messageGo to next message
Michael Ngong
Messages: 4
Registered: June 2001
Junior Member
I beleive imports are not backward compatible.
at least the error message said so in my Case
Thanks Mike

----------------------------------------------------------------------
Re: export from 8.1.6 and import into 8.1.7 [message #69189 is a reply to message #69176] Mon, 19 November 2001 20:08 Go to previous messageGo to next message
Ritesh
Messages: 38
Registered: November 2001
Member
hi...guys
even i am facing a typical problem while exportin from 8.1.6 to 8.1.7 , it says invalid column name and no statements persed . has any body faced same problem, and i am willing to know if anybody can suggest me , a method to solve it.

----------------------------------------------------------------------
Re: export from 8.1.6 and import into 8.1.7 [message #69192 is a reply to message #69189] Mon, 19 November 2001 22:10 Go to previous message
steffi disque
Messages: 3
Registered: November 2001
Junior Member
Hi,
during trying to solve my problem with import 8.1.7 and export in 8.1.6. I rerun catexp.sql (8.1.6) on the machine with 8.1.7. Here I got the same message with invalid column. So I ran catexp.sql (8.1.7) again. There is no error message for the import, but I still can not export the data.
Still waiting for a solution.
Steffi

----------------------------------------------------------------------
Previous Topic: Re: FREE OCP PAPERS
Next Topic: Re: I want to rename a tablespace
Goto Forum:
  


Current Time: Fri Apr 19 15:10:50 CDT 2024