Question: how to import data from oracle to sql server?
Answer: Use a tool such as Microsoft SQL Server Migration Assistant for Oracle. Use SQL Server Integration Services (SSIS) Create a Linked Server on SQL Server pointing to the Oracle database. Export Oracle data to a CSV file and then import the data to SQL Server via bulk copy.