Using the Root Container Extract from PDB
To capture from a multitenant database, you must use an Extract that is
configured at the root level using a c##
account. To apply data
into a multitenant database, a separate Replicat is needed for each PDB, because a
Replicat connects at the PDB-level and doesn't have access to objects outside of
that PDB
One Extract group can capture from multiple pluggable databases to a
single trail. In the parameter file, source objects must be specified in
TABLE
and SEQUENCE
statements with their fully
qualified three-part names in the format of
container.schema.object
.
As an alternative to specifying three-part names, you can specify a
default pluggable database with the SOURCECATALOG
parameter, and
then specify only the schema.object
in subsequent
TABLE
or SEQUENCE
parameters. You can use
multiple instances of this configuration to handle multiple source pluggable
databases. For example:
SOURCECATALOG pdb1 TABLE phoenix.tab; SEQUENCE phoenix.seq; SOURCECATALOG pdb2 TABLE dallas.tab; SEQUENCE dallas.seq;