Question: how to export data from sql server to oracle database?
Answer: Goto the source schema on SQL Server.
Right click > Export data.
Select source as current schema.
Select destination as "Oracle OLE provider"
Select properties, then add the service name into the first box, then username and password, be sure to click "remember password"