Home Forums SQL Server 7,2000 Administration How to import Oracle dmp file into SQL Server 2000 or 2005? RE: How to import Oracle dmp file into SQL Server 2000 or 2005?

  • Jay, without more information I am not really able to assist further. The first thing I would suggest you do is find the DBA for the Oracle database, you are most likely going to need some assistance with this. You need to be able to get connected to the database. Do you have a login to the box on which the Oracle database resides? If not you will have to connect remotely, possible. In either case the DBA is going to have to assist you. If you are on your own then you may have a long haul trying to learn enough about Oracle to configure the connectivity. Once you get connected the user you connect to must have privileges to import, again you may need assistance from the DBA. Once you get to that point the import is fairly straightforward. If you are unable to resolve the connectivity issues then it may be easier to just connect directy to the oracle database from which the export file you have came form and move data directly from there. Good luck.