Hi, Gurus
Q for you.. I have a .dmp file that has been created by Oracle. I want to import this file into SQL server 2000 or 2005 without restoring into Oracle db which I dont know how to do that.
Any idea?
Thx in advance
Jay
Sorry, it can't be done. Oracle dmp files can only be read by the Oracle import utility. You'll have to import the contents of the file into an Oracle database then import the data into SQL Server using DTS or SSIS.
Greg
OK.. Then
I dont have much choices.. I try learn , I mean quick learn, how to import dmp file..
I am looking at article about importing but do you, I mean anybody, have any web site that I can reference?
Thx
Can you elaborate on that option? Or did you miss-read the post. Even Oracle has issues between versions of .dmp files, and they created them.
Using the imp/exp commands from Oracle, you can import into an Oracle DB. Then you can use the import/export from Enterprise Manager/Management Studio to import from Oracle into SQL Server.
Can't say for sure, but you might be able to do something with DTS, but I have never tried.
My VS 2005 is screwed up at the moment, or I would look at integration packages.
Thx.. Bill
Actually that is what I am trying to do but I can not access db. I've got an error message saying that Protocol Adapter error and other one is login failure.. I think there is internal password to access master db (I assume that is master db)..
Yes.. I used FROMUSER but did not work so that I am using FULL which is full import but no luck so far..
