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?

  • DOcumentation for the import/export utility can be found at http://www.oracle.com/technology/index.html. Look under the version of oracle you are using for the utilities manual. It documents import/export. I am assuming you have access to a machine with an oracle database on it already. If you want the whole database you should create an empty database and do a full import. If you only want a particular user precreate that user in the Oracle database and qualify the import command with fromuser=<user in the original database> touser=<user in the database you are importing into>. That shoould do it.