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

  • Status Closed
  • Budget N/A
  • Total Bids 2

Project Description

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

Get free quotes for a project like this

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online