What Are The Steps Required To Add A New Table To An Existing Replica – InterviewSolution

1.

What Are The Steps Required To Add A New Table To An Existing Replication Setup?

Answer»

The steps to be executed would be the following:

INCLUDE the new table to the Extract & pump PROCESS.
Obtain starting DATABASE SCN and COPY the source table data to the target database
Start REPLICAT on target at the source SCN database point.

The steps to be executed would be the following:

Discussion

No Comment Found

Related InterviewSolutions

We Want To Setup One-way Data Replication For My Online Transaction Processing Application. However There Are Compressed Tables In The Environment. Please Suggest How I Can Achieve It?
I Am Migrating My Oracle Database From Non-exadata To Exadata But My Source Ogg Software And Target Ogg Software Versions Are Different (say Source Is Running Ogg 11.1 And Target Is Running Ogg 11.2). How Can I Configure My Ogg Process To Work In Such Configuration?
What Are The Different Ogg Initial Load Methods Available?
I Have A Table Called ‘test’ On Source And Target With Same Name, Structure And Data Type But In A Different Column Order. How Can You Setup Replication For This Table?
What Is The Best Practice To Delete The Extract Files In Ogg?
What Parameters Can Be Used To Configure Oracle Goldengate To Extract Data From Archived Redo Log Files Only?
I Have A One-way Replication Setup. The System Administration Team Wants To Apply An Os Patch To Both The Ogg Source Host And The Target Servers. Provide The Sequence Of Steps That You Will Carry Before And After Applying This Patch?
What Are The Basic Resources Required To Configure Oracle Goldengate High Availability Solution With Oracle Clusterware?
What Is The Purpose Of The Defgen Utility?
How Do You Create A Csv File From The Extracted Data?