Home » RDBMS Server » Server Utilities » Import from 9i to 8i
Import from 9i to 8i [message #228888] Wed, 04 April 2007 08:31 Go to next message
jesuisantony
Messages: 132
Registered: July 2006
Location: Chennai
Senior Member
Hi,

We have a requirement in one of the projects to import the contents of 9i to 8i. Got the error message "IMP-00010
not a valid export file, header failed verification
". Can you please let me know if there is any workaround for this?

Regards,
Antony
Re: Import from 9i to 8i [message #228889 is a reply to message #228888] Wed, 04 April 2007 08:33 Go to previous messageGo to next message
joy_division
Messages: 4641
Registered: February 2005
Location: East Coast USA
Senior Member
You must use the export of the lower version.
Re: Import from 9i to 8i [message #228890 is a reply to message #228888] Wed, 04 April 2007 08:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
may be your dumpfile is corrupt.
Did someone try to edit it? or How was the FTP/transfer done?
Usually, you use the lower version of exp/imp to export and to import. What was the version of exp (that created dumpfile)?
Re: Import from 9i to 8i [message #228912 is a reply to message #228888] Wed, 04 April 2007 09:14 Go to previous messageGo to next message
jesuisantony
Messages: 132
Registered: July 2006
Location: Chennai
Senior Member
Hi,

The dump is not corrupted as the file gets imported in a 9i database. The export file is of version 9i. The requirement is to get it imported on an 8i database. If there is no possibility to go for degradation in the import, can you let me know a relevant document for the same. It will help me in updating the project team.
Re: Import from 9i to 8i [message #228915 is a reply to message #228912] Wed, 04 April 2007 09:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you want to import in a 8i database, you have to export with the 8i export binary.

Regards
Michel
Re: Import from 9i to 8i [message #228919 is a reply to message #228912] Wed, 04 April 2007 09:21 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> The export file is of version 9i
I assume you did an export of this 9i database using an 9i version of imp.
So you need to install the 9i exp/imp views in the 8i database by running catexp.sql logged in as sys (From the 9i installation/oracle_home login as sys into 8i database and execute $9i_ORACLE_HOME/rdbms/admin/catexp.sql).
Now your 9i imp tool when connected to the 8i database will understand and use the appropriate exp/imp views.

PS:
Take a backup of catexp.sql@$8i_ORACLE_HOME.
If you want to use 8i exp/imp again,run this catexp.sql against the 8i database (Just undoing what we did above).
Re: Import from 9i to 8i [message #228926 is a reply to message #228919] Wed, 04 April 2007 09:49 Go to previous messageGo to next message
jesuisantony
Messages: 132
Registered: July 2006
Location: Chennai
Senior Member
Yes I ran the catexp.sql of 9i in the 8i database but still I am facing the same error.
Re: Import from 9i to 8i [message #228928 is a reply to message #228926] Wed, 04 April 2007 09:51 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
The dump is not corrupted
Then it is possible your dump file corrupted...please export again your database and try to import.


Regards
Taj
Re: Import from 9i to 8i [message #228929 is a reply to message #228926] Wed, 04 April 2007 09:54 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Post your exact error message.
Re: Import from 9i to 8i [message #228931 is a reply to message #228929] Wed, 04 April 2007 10:07 Go to previous messageGo to next message
jesuisantony
Messages: 132
Registered: July 2006
Location: Chennai
Senior Member
Error Message :

Import: Release 8.1.7.0.0 - Production on Wed Apr 4 20:36:27 2007

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully
Re: Import from 9i to 8i [message #228932 is a reply to message #228931] Wed, 04 April 2007 10:11 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
As per your previous postings,
You are supposed to use 9i version of imp (only for that reason we executed the catexp.sql).
But you are invoking 8i version.
Re: Import from 9i to 8i [message #228939 is a reply to message #228926] Wed, 04 April 2007 10:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
jesuisantony,

This is wrong.
You have to export your 9i db with 8i binary.
This is the only solution to import in an 8i database.

Regards
Michel
Re: Import from 9i to 8i [message #228945 is a reply to message #228939] Wed, 04 April 2007 10:58 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1195235608978

Above is another one ...

Regards
Taj
Re: Import from 9i to 8i [message #229109 is a reply to message #228945] Thu, 05 April 2007 07:22 Go to previous message
jesuisantony
Messages: 132
Registered: July 2006
Location: Chennai
Senior Member
Thanks Michel/Taj for the confirmation.
Razz
Previous Topic: Import SQL Loader
Next Topic: Importing file with column header
Goto Forum:
  


Current Time: Wed Dec 07 03:15:22 CST 2016

Total time taken to generate the page: 0.12171 seconds