Oracle : Adding new table to existing GoldenGate Replication without downtime

Adding new table to existing GoldenGate Replication In this article, we will add a new table in existing GG replication setup without downtime using filter (@GETENV (‘TRANSACTION’,’CSN’) > scn number); Source : GG11 Target : GG12 Source :  Connect and Login to the ggsci 

Read More

Oracle 19c Software Installation On Linux 7.6

In this article, we will see Oracle 19c (19.3) Software Installation On Linux 7.6 Click here to Download Oracle 19c Software from Oracle Support. Create a directory for ORACLE_HOME

Unzip the oracle 19c software

Goto Oracle home location and run the ./runinstaller

Start… Read More

Excluding tables while performing datapump import from Full schema backup

Hello Everyone, In this article , we will learn Excluding tables while performing datapump import from full schema backup. Database : AVPROD Schema : OT Check objects count  in OT Schema.

Take full schema backup using schema=OT

Full schema backup completed ,… Read More