Home » RDBMS Server » Server Utilities » Import from 8.1.7 to 8.1.6
Import from 8.1.7 to 8.1.6 [message #72357] Wed, 28 May 2003 00:53 Go to next message
Suman Seshadri
Messages: 3
Registered: May 2003
Junior Member
I have a dmp file created using Oracle 8.1.7. I want to import it into my machine which has Oracle 8.1.6 server.

When I try to import, I get the following error:

Export file created by EXPORT:V08.01.07 via conventional path

Warning: the objects were exported by CO, not by you

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 understand that this is due to incompatability between export done in 8.1.7 and import into 8.1.6. One solution,(please correct me if I am wrong) is to export once again using 8.1.6 utility and then try and import it into my machine which has 8.1.6. Is this the only solution or is there an alternative which will help me avoid exporting once again ?

Any help is appreciated.
Thanx in advance,
Suman
Re: Import from 8.1.7 to 8.1.6 [message #72358 is a reply to message #72357] Wed, 28 May 2003 06:00 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
yes.
always use a lower version of EXP ( in your case 816) against a higher version of database (817) and
use the same lower version of IMP to import into the database.
Re: Import from 8.1.7 to 8.1.6 [message #72359 is a reply to message #72358] Wed, 28 May 2003 08:01 Go to previous message
Suman Seshadri
Messages: 3
Registered: May 2003
Junior Member
Thanx Mahesh for your reply.

-Suman
Previous Topic: Whether Windows XP Prof. accepts Oracle 9i Enterprise
Next Topic: when SQL*Loader
Goto Forum:
  


Current Time: Fri Jun 28 22:10:22 CDT 2024