August 30, 2005 at 6:10 am
I have exported oracle dmp. I am not able to import it into SQL Database.
If you know how to import oralce dmp into SQL or MS Access please post your reply.
Thanks & Regards
Vanan KT
August 31, 2005 at 3:16 am
H!!,
There are many ways by which you can transfer oracle user to SQL server.IF you intend to transfer only the tables constraints,index and data here is the best solution .
- Take out the table creation script from the oracle user which you want to move to oracle and change the data types eg - varchar --> varchar2 numeric --NUMBER
etc with excact length .
-Use DTS to port data from oracle to SQL server
-create the constraints ,indexes ,sequences ..etc
revert if you have any difficluty in doing so..
regards,
vinod (DBA) 09840856202
August 28, 2008 at 6:15 am
It is late answer but may help:
Visit http://www.convert-in.com - there are utilities to import Oracle DMP to many other DB
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply