This Chapter presented detailed information
on the configuration of the Capture process and the Propagation
process. Examples have been used to illustrate the replication
The main points of this chapter include:
There are multiple methods for
configuration of the Capture process. Each configures at
various levels within the database. These levels are: Table
level; A subset of Table level: Schema level; and Database
There are different sets of procedures that
can be used to manage the Capture process. To stop, start and
drop the capture and for adding extra attributes to the captured
LCR(s), appropriate procedures were introduced.
By using the create_capture
procedure, a flexible type of Capture process can be created
where the administrators are able to specify the start_scn
and first_scn values for the capture. This gives better
control over the capture mechanism.
Propagation rules can also be configured at
various levels such as Global, Schema and Table levels.
In the next chapter, the configuration
details of the Apply process will be examined.