I am trying to runt import/export but getting the following error:
Import: Release 220.127.116.11.0 - Production on Tue Jul 30 11:23:09 2002
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 18.104.22.168.0 - Production
With the Partitioning option
JServer Release 22.214.171.124.0 - Production
IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully
I am using Oracle 8.1. My imp/exp works at all other machines, except for mine.
Thanks in advance,
07-30-2002, 12:31 PM
Export out with the old version, import into the new with the newer version of Oracle. Version to version being the same, use exp and imp from that version.
Going from 8.1.6 to 126.96.36.199, for example. Use 8.1.6's export utility to create the export dump file. Use 188.8.131.52's import utility to bring the dump file in to the 9i database.
07-30-2002, 12:32 PM
I think either this is a bug or your .DMP file is corrupt, can you run the export again?
07-30-2002, 12:49 PM
I have a machine that is running Oracle8.1.7 and I run an export on that machine.
My machine runs Oracle 8.1.5, and I get the error when I try to run an import into it.
If I export on the same machine it works fine.
So, is there anyway I can run exp on a machine that has Oracle817, and import on machine that has Oracle815???
07-30-2002, 12:56 PM
Try using the export utility of your older version against the database of the newer version, and then use the older version import to do the import into the older version.
07-30-2002, 01:14 PM
Sorry Boris; I misread the question, I thought you were going the right way. The general rule of thumb with import/export is that you can import into the same version or higher, not the opposite.
07-30-2002, 01:17 PM
It's always a good practice to use the lower version of binaries to backup all the databases, if your farm contains different databases of different versions.
So use 8.1.5 binary's to export 8.1.5(your box) and other 817 db's