To Import a Unix Oracle 7 .dmp file into Windows Oracle 8

Cancelled Posted May 1, 2005 Paid on delivery
Cancelled 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

Data Entry Data Processing Linux Project Management Windows Desktop

Project ID: #16938

About the project

2 proposals Remote project Active Jan 15, 2006

2 freelancers are bidding on average $80 for this job

softsolution

let us start and end now.

$100 USD in 1 day
(0 Reviews)
0.0
rkannanchari

This type of Data handling has been done by me several times. Hence use my services.

$60 USD in 1 day
(0 Reviews)
0.0