Valid For
Extract and Replicat
Description
Use the SOURCECATALOG
parameter to specify one of the following for subsequent TABLE
or MAP
statements that contain two-part names, where three-part object names are required to fully identify a default source Oracle pluggable database (PDB)
This parameter provides an efficient alternative to specifying the full three-part object name (container.schema.object
or catalog.schema.object
) when specifying source objects from an Oracle consolidated database. Only the two-part name (schema.object
) need be specified in subsequent TABLE
or MAP
statements when SOURCECATALOG
is used. You can use multiple instances of SOURCECATALOG
to specify different default containers or catalogs for different sets of TABLE
statements (or SEQUENCE
statements, if Oracle).
Three-part name specifications encountered after SOURCECATALOG
override the SOURCECATALOG
specification in a TABLE
statement, MAP
statement, or other parameter that takes object names as input.
Default
None
Syntax
SOURCECATALOG {container}
Example
In the following example, SOURCECATALOG
is used to specify three different source Oracle PDBs in an Extract parameter file.
SOURCECATALOG FINANCETABLE SAP.*; TABLE REPORTS.*; SOURCECATALOG HRTABLE SIEBEL.*; TABLE REPORTS.*; SOURCECATALOG MFG TABLE CUSTOMER.ORDERS; TABLE REPORTS.*; TABLE HQ.LOCATIONS.*;
In this example, Extract captures the following:
All tables in the SAP
and REPORTS
schemas in the FINANCE
PDB.
All tables in the SIEBEL
and REPORTS
schemas in the HR
PDB.
All tables in the CUSTOMER
and REPORTS
schemas in the MFG
PDB.
For the last TABLE
statement, Extract captures all tables in the LOCATIONS
schema in the HQ
PDB. This statement is a fully qualified three-part name and overrides the previous SOURCECATALOG
specification.