Oracle advanced replication

<<Previous   Next>>

Oracle advanced replication - June 11, 2010 at 15:30 PM by Babu Kunwar

What is replication? Explain its purpose.

Explaining replication in simple words is little bit tough but in order to understand it let us assume an example: Let us suppose that we have a database at location A and another database.............
Read Answer

Oracle Server supports two different forms of replication: basic and advanced replication. Explain difference between these.

Basic replication is implemented using standard CREATE SNAPSHOT or CREATE MATERIALIZED VIEW statements. It can only replicate data and not procedures, indexes replication is always one-way, and snapshot copies are read only..................
Read Answer

What is the difference between a snapshot and a materialized view?

There is no basic difference between the materialized view and snapshot. Snapshot is an old term for materialized view. The only difference is that it is redefined in the later version..................
Read Answer

Describe how to implement basic snapshot replication.

Snapshot implementation can be done in several different ways and from several different locations. In most cases, we want to use deployment templates to locally pre-create a snapshot environment...............
Read Answer

What object types can and cannot be replicated in oracle?

Sequences LONG and LONG RAW data types and user defined data types cannot be replicated inside Oracle database.................
Read Answer

Describe how to set up multi-master replication.

Following is the query to setup multi-master replication:...................
Read Answer

What is a surrogate repadmin user and how is one created?

Surrogate repadmin user can be created by executing the query: We need to make the following API................
Read Answer

Describe how to monitor replication.

We can monitor replication from both the command line and within your programs. The ttStatus and ttRepAdmin utilities are used for the command line utilities. To manage replication from the programs....................
Read Answer

Explain how to change the definition of a replicated table.

Connect to the master definition site as the replication administrator. If necessary, then inactivate the master group......................
Read Answer

Explain how to resolve replication conflicts. 

Conflict means that there are two materialized view of your db for example A and B, and if both update a column at same time then conflict occurs. In order to resolve the replication conflict..............
Read Answer

<<Previous   Next>>

What dynamic data replication?

Dynamic data replication is the way in which updating or inserting records in remote database through database triggers.............

Read-only replication and snapshots

Replication is the process of copying database into one or more databases to make a system distributed................

Write your comment - Share Knowledge and Experience