Most databases require only two-part names to be specified, in the following format:

owner.object

For example: HR.EMP

Where:

owner is a schema or database, depending on how the database defines a logical namespace that contains database objects. object is a table or other supported database object.

The databases for which Oracle GoldenGate supports two-part names are as follows, shown with their appropriate two-part naming convention:

• Db2 for i: schema.object and library/file(member)

• Db2 LUW: schema.object

• Db2 on z/OS: schema.object

• MySQL: database.object

• Oracle Database (non-CDB databases): schema.object

• SQL Server: schema.object

• Teradata: database.object