To Import a Unix Oracle 7 .dmp file into Windows Oracle 8
$30-100 USD
Paid on delivery
Let me explain it pointwise
1. I have a Unix server Running Oracle 7.2
2. I have a user called 'Namankan' on Oracle DB
3. I have to shift the entire tables of user 'Namankan' from this System to a new server running Windows XP (or NT) with Oracle 8 (Not 8i)
If you are going to suggest me that I spool the entire data into text files and import them by running SQL*Loader in the new system, Pls dont suggest....... coz i) Data is too large, ii) Table level validations in database will not allow the data to go in
I have tried making a .dmp file using exp command on Unix Machine with default parameters, and have exported the entire data into a file called [url removed, login to view] which is 175 MB, zipped into 28MB
Then I have taken this file onto Windows system with Oracle 8 and tried to import it through Imp80 command
It says
* Invalid Header Information, OS different (some such 2-3 lines)
As suggested by someone in a yahoo chat room, I Have tried to change the header information in .dmp file using a hex editor, I matched it to same as it was in a sample .dmp I made using exp80 command on my windows machine.......... Sometimes, it asks 2-3 questions and after replies starts dumping junk......... sometimes it hangs the system
I also came across to a data extraction program NXTract, however, its similar to spooling of files, even if it extracts data from .dmp file, so it is useless for me
I need an expert, who knows how to do it, and who can sit across online with me in MSN and guide me steps to do it, I will do it myself............ as the data is confidential
If you know the solution, you just gotta charge for your advice
And its VERY VERY URGENT, I will choose the winner, the moment I m convinced with someone's bid that he can get it done
Project ID: #16938