Using Two-Part Names

In a two-part name, you specify the schema and the object name. To map the catalog portion of the name, you must link it to an Extract or Replicat group. Only one catalog can be linked to an Extract or Replicat group. To capture from, or apply to, more than one catalog, you must create an Extract group for each one on the source and a Replicat group for each one on the target. To link a catalog to an Extract group, use the SOURCEDB parameter. To link a catalog to a Replicat group, use the TARGETDB parameter. The USERID portion of SOURCEDB and TARGETDB specifies the default schema.

SOURCEDB catalog USERID schema

TARGETDB catalog USERID schema

Note:

The API that is used by Extract does not log in to the database, so an authentication password is not required.