Oracle GoldenGate Articles Dear Readers, Please check below articles to get good knowledge on Oracle GoldenGate AWS Cloud. SNO DESCRIPTION ARTICLE LINK 1 Shell Script to get EMAIL alerts for Lagging between GoldenGate Processes https://www.ktexperts.com/shell-script-to-get-email-alerts-for-lagging-between-goldengate-processes/ 2 Shell Script to get EMAIL alerts for STOPPED Processes… Read More
Dear Readers, In this article we will see Oracle GoldenGate 12c Security (Useridalias & Credential Store). We care for your speed. Below is an easy way to perform Oracle GoldenGate 12c Security (Useridalias & Credential Store) ADDCREDENTIALSTORE is a new command in Oracle GoldenGate 12c The… Read More
Dear Readers, In this article we will see Logdump utility in Oracle GoldenGate 12c. We care for your speed. Below is an easy way to perform Logdump utility in Oracle GoldenGate 12c Logdump utility comes by default with goldengate software. It is part of goldengate home.… Read More
Dear Readers, In this article we will seeData Selection and Filtering in Oracle GoldenGate 12c. We care for your speed. Below is an easy way to perform Data Selection & Filtering in Oracle GoldenGate 12c. We can perform Data selection or Filtering in GoldenGate in two … Read More
Dear Readers, In this article we will see Performing an Initial load with Oracle GoldenGate 12c. We care for your speed. Below is an easy way to Performing an Initial load with Oracle GoldenGate 12c. What is GoldenGate Initial Load ? Loads the data directly from source… Read More
Dear Readers, In this article we will see Mapping Columns on Oracle GoldenGate 12c. We care for your speed. Below is an easy way to Mapping Columns on Oracle GoldenGate 12c Oracle GoldenGate provides for column mapping at the table level and at the global level. Default… Read More
Dear Readers, In this article we will see IgnoreDelete and IgnoreUpdate parameters in Oracle GoldenGate. This article covers Oracle GoldenGate IgnoreDelete and IgnoreUpdate parameters for Oracle GoldenGate IGNOREUPDATES Parameter IGNOREDELETES Parameter NOTE : The parameters used in this article could be used either in Extract,Data… Read More
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
Dear Readers, In this article we will see the sub-directories of Oracle GoldenGate we have totally 11 subdirs available in Oracle GoldenGate. List of directories : dirdat –> Extract data files dirchk –> Checkpoint file dirtmp –> Temporary files dirrpt –> Report file dirdef –>… Read More
Dear Readers, In this article we will see how to replicate only particular columns to the target table On Source database : Take Dept table and add two more columns
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
SQL> select * from dept; DEPTNO DNAME LOC ---------- -------------- ------------- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON SQL> alter table dept add Mobile number(10); Table altered. SQL> alter table dept add Pin number(6); Table altered. SQL> select * from dept; DEPTNO DNAME LOC MOBILE PIN ---------- -------------- ------------- ---------- ---------- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON |
Now on source dept have 5 columns(DEPTNO,DNAME,LOC,MOBILE,PIN) On Target database we should add same… Read More
