This content has been marked as final. Show 4 replies
No. You cannot simply import binary data files from a 3rd party database directly into Oracle.
You can use bcp on SQL-Server to unload the data to CSV and then use Oracle's SQL*Loader to load it.
You can run a SQL-Server database instance and an Oracle database instance, and use a heterogeneous database link from Oracle (working via ODBC) to connect to SQL-Server - and use SQL statements to pull object definitions and data from SQL-Server into Oracle.
1º Restore the backup into a sql server.
2º Use a MIGRATION SQL SERVER TO ORACLE TOOL.
You can also do that by installing Oracle Database Gateway for MS SQLServer .Create DB link use Oracle Heterogeneous Services to fetch data from sql server
Use following utility to import data from SQL Server to oracle.
EMS Data Pump for Oracle