importing a *.dmp file from 9i DB to 8i

[nouf]

i am trying to import a dmp file (hr.dmp)
it was exported from a 9i dadabase.

i did the following:
-------------------------------------------------------
C:\>imp hrr/hr

Import: Release 8.1.6.0.0 - Production on Thu Oct 16 13:51:49 2003

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


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

Import file: EXPDAT.DMP > c:\hr.dmp

Enter insert buffer size (minimum is 8192) 30720>

IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully
-------------------------------------------------------

is the problem is using 8i and if it is how can i solve it
and if not waht is the problem.

remark : the same dmp file imported successfully when i used 9i database

regards,,,

 

[dbtoo2001]

To import into your 8i database, the export from 9i would need to be performed with the exp command from the 8i (not the 9i) oracle home. Then you should be able to import it into the 8i database.

 

[nouf]

to dbtoo2001;

so there is no way to import this file using 8i !!!!!

 

[dbtoo2001]

From Oracle's Metalink:
The export dump files cannot be read by IMPORT utilities of previous maintenance releases and versions. So, a version 9 export dump file cannot be imported by a version 8i IMPORT utility (possible errors: IMP-10 and IMP-21), and a version 8 export dump file cannot be imported by a version 7 IMPORT utility (possible errors: IMP-69 and IMP-21). In both cases, the import will terminate with the error IMP-0 "Import terminated unsuccessfully".

 

[dsanchez2]

The reason for this restriction is that Oracle 9i has new features. When you export with 9i export the dump file created includes support for the new features. The Oracle 8i import does not know about the new 9i features, so it can not import the 9i created dump file.

However if you use Oracle 8i export to export from the 9i database, information about the new features will not be exported. So you can import the dump file created.

This is similar to MS-Word. Word-97 can not open Word-XP documents. You need to save the documents in Word-97 format if you want to open the document in Work-97.

 

[Murt]

Has anyone successfully imported from 9i to 8i ? Everything you say makes sense about using the 8i utilities for both export and import but in practice it won't work for me !
With 8.1.7 exp bombs out with a windows error "EXP.exe has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created."

Any help would be appreciated - thanks.

 

[Turkbear]

Hi,
What that usually means is that your 8.1.7 ( actually it looks like an 8.1.6) installation may be hosed in some way or is not configured correctly.
If you have both 9 and 8 on the same box, be sure the ORACLE_HOME is set to the 8.1.7 home before running any 8.1 commands..Also start in the 8.1.7 home's bin directory when running the EXP command.

Can you post the full text of your command line use of EXP?
( Also, what version of Windows?)

 

[Murt]

Hi,

I am running Windows 2000 on my PC, 8.1.7 client is correctly installed and configured. I can connect to any database (8 or 9) thru sqlplus but exp bombs out even if run from the bin directory.
The 9i DB I am connecting to is 9.2.0.1.0 running on Solaris.
I have also tried using exp on 2 solaris boxes with 8.1.6 server installed and it gives me a "productionSegmentationFault" message in both cases.

My exp command is very straightforward ...

exp user/password@dbname file=user.dmp log=user_exp.log

Have you moved a DB from 9 to 8 yourself ?

 

[Turkbear]

Yes..
But, since the error is not an Oracle one but a Windows one ( at least the error on the W2K box)..There is something about the EXP.EXE that is not behaving..This need not affect sqlplus , so the fact that it works is not dispositive.
Can you run IMP.EXE without errors?
Can you use EXP to export from 8.1.7 databases without errors?

 

[Murt]

Yes, IMP and EXP work perfectly against an 8.1.7 database.
It fails against 8.1.6 with 904 errors but exp is not backward compatible anyway so this doesn't bother me.

At least I now know that it is possible - I was beginning to wonder !