Converty MySQL table to Oracle using SQL Loader
oracle sql and dba tutorial logo


Oracle DBA

Learn Oracle 11g / 12c Database Admin step by step

Oracle SQL

Tutorial for Oracle SQL

Oracle DBA Interview Questions

Most asked Oracle DBA Interview Questions.

60 Technical Questions
42 Backup & Recovery Questions

Unix For Oracle DBA 20 Questions

Download Oracle 11g / 12 c Software

Links to Download Oracle 12c / 11g for Linux, Windows etc.

MySQL Tutorial

Learn MySQL step by step










Migrate MySQL to Oracle - Tutorial Step 2

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

Transfer file to linux pc

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 step



HomeContact Us

Data Loader

Data Loader is a simple yet powerful tool to
export and import Data between many common database formats

Forms Data Loader

Tool to load data into Oracle E-Business Suite R12 / Oracle Apps using Macros and Forms Record and Playback

Interface Computers Academy © 2007-2017 All Rights Reserved