Applying to Pluggable Databases
Replicat can only connect and apply to one pluggable database. To
specify the correct one, use a SQL*Net connect string for the database user that you
specify with the USERID
or USERIDALIAS
parameter.
For example: GGADMIN@FINANCE
. In the parameter file, specify only
the schema.object
in the TARGET
portion of
the MAP
statements. In the MAP
portion, identify
source objects captured from more than one pluggable database with their three-part
names or use the SOURCECATALOG
parameter with two-part names. The
following is an example of this configuration.
SOURCECATALOG pdb1 MAP schema_1.tab, TARGET 1; MAP schema_1.seq, TARGET 1; SOURCECATALOG pdb2 MAP schema_2.tab, TARGET 2; MAP schema_2.seq, TARGET 2;
The following is an example without the use of
SOURCECATALOG
to identify the source pluggable database. In
this case, the source objects are specified with their three-part names.
MAP pdb1.schema_1.tab, TARGET 1; MAP pdb1.schema_1.seq, TARGET 1;
To configure replication from multiple source pluggable databases to multiple target pluggable databases, you can configure parallel Extract and Replicat streams, each handling data for one pluggable database. Alternatively, you can configure one Extract capturing from multiple source pluggable databases, which writes to one trail that is read by multiple Replicat groups, each applying to a different target pluggable database. Yet another alternative is to use one Extract writing to multiple trails, each trail read by a Replicat assigned to a specific target pluggable database :