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.



Migrate Data From MySQL to Oracle       

How to migrate data from MySQL to Oracle using SQL Loader tool

For example suppose we have a table "Orders" in MySQL running in Windows with the following structure

MySQL Table structure

This table has some 1000 rows and  we need to load these rows into a table in Oracle running under Linux O/s.

Here are the specs of both PC's

Source

Database : MySQL
Table Name: Orders
O/s: Windows
IP Address:192.168.50.1 

Target

Database: Oracle
Table Name: Orders (Doesn't exist)
O/s : Linux
IP Address: 192.168.50.132

To migrate the MySQL table we need to do the following

Step 1

First Export the rows from MySQL table to a CSV or any delimited file. To export the rows we can use HeidiSQL or any other similar tool

To export the rows to a CSV file using HeidiSQL ,

Open HeidiSQL tool in Source PC

Login to MySQL server by typing your username and password

Select the MySQL Database in which "Orders" table is residing from from Left Panel

Expand the database node and select Orders table in the left panel

Then on the right panel, click the on the "Data" tab to view the data from "Orders" table as shown in the picture below

table data

Right Click on any column in the data grid and select "Export Grid Rows" option

export rows

You will see a Export Grid rows dialog window. In this window enter CSV file name as "test.csv" and select "Complete Rows" option and De-Select "Include Column Names" checkbox and click OK

export rows option 

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