Home » RDBMS Server » Server Utilities » exporting from 10.1.0.2 , importing into 10.1.0.3
exporting from 10.1.0.2 , importing into 10.1.0.3 [message #203438] Wed, 15 November 2006 02:43 Go to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
Hello,

When I try to export from 10.1.0.3 database and import the data into 10.1.0.2 database, I get the error IMP-00010 Invalid headerfile specification. Is it because of the version incompatibility? or some other reason?

Thanks,
Nirav
Re: exporting from 10.1.0.2 , importing into 10.1.0.3 [message #203440 is a reply to message #203438] Wed, 15 November 2006 02:51 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi nirav.

IMP-00010 Invalid headerfile specification

bcoz of corrupted export dump file you have to export again and import ur operation.


hope this helps.
Mohammad Taj.
Re: exporting from 10.1.0.2 , importing into 10.1.0.3 [message #203442 is a reply to message #203440] Wed, 15 November 2006 02:54 Go to previous messageGo to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
Hi ,

Thank you .. I think the export file is not corrupted...when I do the export it says export completed successfully...in case of any corruption ,export will not work right?

and even if I repeat the export , I get the same error..
Re: exporting from 10.1.0.2 , importing into 10.1.0.3 [message #203447 is a reply to message #203442] Wed, 15 November 2006 03:02 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi nirav

IMP-00010: not a valid export file, header failed verification
Cause: Either the file was not generated by Export or it was corrupted.
Action: If the file was indeed generated by Export, report this an Import bug and submit the export file to customer support.



hope this helps
MOhammad Taj.
Re: exporting from 10.1.0.2 , importing into 10.1.0.3 [message #203449 is a reply to message #203442] Wed, 15 November 2006 03:03 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Are NLS settings the same in both databases?

Did you FTP the export file as ASCII (instead of binary)?
Re: exporting from 10.1.0.2 , importing into 10.1.0.3 [message #203453 is a reply to message #203449] Wed, 15 November 2006 03:11 Go to previous messageGo to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
Thank you Littlefoot.

Yes I did the binary mode transfer..actually this issue is one of my friends and I do not have the 10g environment. Not sure about nls settings but I guess if they are different then it will be automatically converted right?

One more thing: I just noted that we used the exp and imp commands not the expdp and impdp command..is that fine?

[Updated on: Wed, 15 November 2006 03:12]

Report message to a moderator

Re: exporting from 10.1.0.2 , importing into 10.1.0.3 [message #203490 is a reply to message #203453] Wed, 15 November 2006 04:57 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Different NLS settings sometimes cause unexpected behaviour and, as I've read about it, it is suggested that both databases have the same NLS's.

Original export and import utilities ('exp' and 'imp') *should* work; however, Oracle encourages you to use export and import data pump ('expdp' and 'impdp') as they support all 10g features (while 'exp' and 'imp' do not).
Re: exporting from 10.1.0.2 , importing into 10.1.0.3 [message #203492 is a reply to message #203490] Wed, 15 November 2006 05:00 Go to previous messageGo to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
This is very helpful! I shall check this and if problems still persist, I will post back...
Re: exporting from 10.1.0.2 , importing into 10.1.0.3 [message #203543 is a reply to message #203492] Wed, 15 November 2006 08:16 Go to previous messageGo to next message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
Ummm, your subject says export from exporting from 10.1.0.2 , importing into 10.1.0.3, but your first message says the reverse.

Your error message is expected if you are exporting from the 10.1.0.3 database using the export from that version.

You cannot export from a higher version and import into a lower version unless you use the export from the lower version.
Re: exporting from 10.1.0.2 , importing into 10.1.0.3 [message #203544 is a reply to message #203543] Wed, 15 November 2006 08:19 Go to previous message
orausern
Messages: 817
Registered: December 2005
Senior Member
joy thanks a lot. I want to try this immediately.
Previous Topic: Data Pump good as it sound's ?
Next Topic: Oracle Import
Goto Forum:
  


Current Time: Wed Dec 07 20:49:31 CST 2016

Total time taken to generate the page: 0.10874 seconds