goldengate

COLS & COLSEXCEPT FILTER in goldengate

                    COLS & COLSEXCEPT filter parameters are used to exclude or include(select) few columns of a table from goldengate extraction. i.e if a table on source has 5 column, a...

Schema replication using oracle goldengate

In this tutorial, we will explain how to do schema replication in goldengate. Schema replication means, replicating all the tables of a schema.   1. add supplemental for all tables of a schema [ ...

Enable DDL replication in goldengate

In this below tutorial, we will enable DDL replication for a table, which is already part of  goldengate replication and currently only DML transactions are getting replicated. TABLE_NAME = APPLIAN...

Adding new table to a existing extract and replicat in goldengate

Below are the steps for adding a new table to the existing extract and replicat. In this example, we will add DBACLASS.SAL table to existing replication. 1.stop extract and pump process [ SOURCE] [cra...

Setting up Table replication in oracle goldengate

In this below tutorial, we will setup one-way goldengate replication for below two tables from database SRCDB to TRGDB. DBACLASS.EMP; DBACLASS.DEPT; SEE – Oracle goldengate Fundamentals NOTE ...

Obey command in goldengate

Like we execute .sql file against SQL, we can write multiple goldengate commands inside a .oby file and execute it against GGSCI prompt using OBEY command. EXAMPLE: In the below example, we will add s...

RMAN-08137: WARNING: archived log not deleted, needed for standby

PROBLEM: Archive logs are not getting deleted with RMAN command, and it is reporting below warnings. [crayon-5bed9f3d07cc4087454079/] CAUSE & SOLUTION: Well, the error clearly says, either goldeng...

Defgen utility in Oracle goldengate

     If source and target table structures are different, like source has then we need to use definition file in replicat file. Example: Here we will generate definition file of a table DBACLASS.E...

ERROR: No checkpoint table specified for ADD REPLICAT

           While adding the replicate, you may get the below error. GGSCI (sec75-2) 2> add replicat LOYTSTR, exttrail /ggatebss/oradata/RBM12C/R4 ERROR: No checkpoint table specified for ADD ...

OGG-01031 There is a problem in network communication

                  While starting the datapump in goldengate version 12.2.0 , you may get below error.   2016-04-14 15:14:39  ERROR   OGG-01031  There is a problem in network communic...

Page 1 of 212
Skip to toolbar