OraFAQ Forum: Server Utilities » Import from 9i to 8i

Home » RDBMS Server » Server Utilities » Import from 9i to 8i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Import from 9i to 8i [message #228888]

Wed, 04 April 2007 08:31

jesuisantony
Messages: 166
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

Report message to a moderator

Re: Import from 9i to 8i [message #228889 is a reply to message #228888]

Wed, 04 April 2007 08:33

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

You must use the export of the lower version.

Report message to a moderator

Re: Import from 9i to 8i [message #228890 is a reply to message #228888]

Wed, 04 April 2007 08:35

Mahesh Rajendran
Messages: 10708
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)?

Report message to a moderator

Re: Import from 9i to 8i [message #228912 is a reply to message #228888]

Wed, 04 April 2007 09:14

jesuisantony
Messages: 166
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.

Report message to a moderator

Re: Import from 9i to 8i [message #228915 is a reply to message #228912]

Wed, 04 April 2007 09:17

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you want to import in a 8i database, you have to export with the 8i export binary.

Regards
Michel

Report message to a moderator

Re: Import from 9i to 8i [message #228919 is a reply to message #228912]

Wed, 04 April 2007 09:21

Mahesh Rajendran
Messages: 10708
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).

Report message to a moderator

Re: Import from 9i to 8i [message #228926 is a reply to message #228919]

Wed, 04 April 2007 09:49

jesuisantony
Messages: 166
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.

Report message to a moderator

Re: Import from 9i to 8i [message #228928 is a reply to message #228926]

Wed, 04 April 2007 09:51

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

Report message to a moderator

Re: Import from 9i to 8i [message #228929 is a reply to message #228926]

Wed, 04 April 2007 09:54

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Post your exact error message.

Report message to a moderator

Re: Import from 9i to 8i [message #228931 is a reply to message #228929]

Wed, 04 April 2007 10:07

jesuisantony
Messages: 166
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

Report message to a moderator

Re: Import from 9i to 8i [message #228932 is a reply to message #228931]

Wed, 04 April 2007 10:11

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: Import from 9i to 8i [message #228939 is a reply to message #228926]

Wed, 04 April 2007 10:48

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator