Two-part Names
Most databases require only two-part names to be specified, in the following format:
owner.objectFor 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.objectandlibrary/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