Cancelled

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

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

Skills: Data Entry, Data Processing, Linux, Project Management, Windows Desktop

See more: nxtract import dmp file, import dmp file oracle unix, oracle import data unix windows, unix import dmp, import oracle dmp unix windows, yahoo 7, sql to oracle, room files, oracle header, online oracle database, how to solution, how do you get linux, guide solution, get expert advice, 7 yahoo, oracle import database windows unix, oracle import unix windows, import dmp, nxtract, oracle import dmp, import unix dmp, oracle nxtract, nxtract oracle, windows system , windows online

About the Employer:
( 15 reviews ) JAIPUR, India

Project ID: #16938

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