Do you need to have in an Oracle database all the data that another BD has in SQL Server? One solution is to do the entire transfer manually, but it is much more practical to have a tool like Export Table for Oracle Standard.
The operation of Export Table for Oracle Standard is as follows: from the data in the original SQL Server, it generates a series of SQL instructions (of the INSERT type) that, when executed, will automatically fill in the database. Oracle data.
The entire process in Export Table for Oracle Standard is done through a wizard, so it is quite easy to carry out. It allows to predefine the DSN of connection to the BDs. It even allows filtering, with the WHERE clause, so that only data that meets certain requirements is transferred.
You can free download Export Table for Oracle Standard 32, 64 bit and safe install the latest trial or new full version for Windows 10 from the official site.