Step 2

We need to transfer this CSV file to Linux Machine where Oracle database is running. We can use any FTP or WinSCP or any similar tool for transferring this file.

I am using free WinSCP a very good tool for transferring files between Windows and Unix Machines, you can download it from here . It's free! 

Start WinSCP and connect to the Linux Machine by typing in IP address, Username and password

Once you have entered the above details you will get a window similar to picture shown below

We need to just drag and drop test.csv file from left pane to right pane to transfer the file from local machine to target linux machine.

When you drop the file in Right Panel it will be copied to the current folder which is usually the home directory of the loged in user.  In our case the file is transferred in "/opt/oracle" folder

Next : write a control file