Đã Hủy

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

Kỹ năng: Nhập liệu, Xử lí dữ liệu, Linux, Quản lí dự án, Màn hình Windows

Xem thêm: nxtract import dmp file, unix import dmp, yahoo 7, room files, oracle header, online oracle database, guide solution, get expert advice, 7 yahoo, oracle import unix windows, import dmp, nxtract, oracle import dmp, import unix dmp, oracle nxtract, nxtract oracle, windows system , windows online, text editor online, program editor online, online unix, get windows, windows xp, windows os, windows do

Về Bên Thuê:
( 15 nhận xét ) JAIPUR, India

Mã Dự Án: #16938

2 freelancer đang chào giá trung bình $80 cho công việc này


let us start and end now.

$100 USD trong 1 ngày
(0 Đánh Giá)

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

$60 USD trong 1 ngày
(0 Đánh Giá)