Migrating Table data from MySQL to Oracle Using SQL* LOADER

Hi Readers, In this article,we will see Migrating Table data from MySQL to Oracle Using SQL* LOADER. Step 1 : Connect to Mysql DB and create a table

Insert data into a table

Crosscheck the data in C_EMP TABLE

Step 2 : … Read More

Oracle to MySQL Heterogeneous Unidirectional Replication

Oracle to MySQL Heterogeneous Unidirectional Replication Hello Readers, In this article we will see how to make Heterogeneous Unidirectional Replication between Oracle and  MySQL. Source : Oracle DB(12.1.0) Target :  MySQL(5.7) Download Goldengate Binaries  Download GoldenGate binaries from Oracle.com using below link(Oracle) https://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html Make sure that you… Read More

INTRODUCTION TO SQL(Article -1)

INTRODUCTION TO SQL Overview : SQL is a language of database, it includes database creation, deletion, fetching rows and modifying rows etc. What is SQL? SQL is Structured/Syntax/Sequential Query Language, which is a language for storing, manipulating and retrieving data stored in relational database. SQL… Read More

DIFFERENCE BETWEEN ORACLE AND MySQL -05

DIFFERENCE BETWEEN ORACLE AND MySQL -05 Please refer my previous articles. DIFFERENCE BETWEEN ORACLE AND MySQL -04 In this article will see few more differences between ORACLE and MySQL. Differences between Oracle and MySQL SNO ORACLE MySQL 1 In Oracle ,we need to write Parameters to set (or)… Read More