OraFAQ Forum: Server Utilities » exporting from 10.1.0.2 , importing into 10.1.0.3

Home » RDBMS Server » Server Utilities » exporting from 10.1.0.2 , importing into 10.1.0.3

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

exporting from 10.1.0.2 , importing into 10.1.0.3 [message #203438]

Wed, 15 November 2006 02:43

orausern
Messages: 826
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

Report message to a moderator

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

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.

Report message to a moderator

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

orausern
Messages: 826
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..

Report message to a moderator

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

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.

Report message to a moderator

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

Littlefoot
Messages: 21813
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)?

Report message to a moderator

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

orausern
Messages: 826
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

Littlefoot
Messages: 21813
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).

Report message to a moderator

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

orausern
Messages: 826
Registered: December 2005

Senior Member

This is very helpful! I shall check this and if problems still persist, I will post back...

Report message to a moderator

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

joy_division
Messages: 4963
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.

Report message to a moderator

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

orausern
Messages: 826
Registered: December 2005

Senior Member

joy thanks a lot. I want to try this immediately.

Report message to a moderator

Previous Topic:	Data Pump good as it sound's ?
Next Topic:	Oracle Import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 08:59:39 CDT 2024