-
Book Overview & Buying
-
Table Of Contents
Oracle GoldenGate 11g Implementer's guide
By :
GoldenGate supports the replication of all DDL commands operating at schema level. By default DDL replication is enabled on the target (Replicat) for data integrity and disabled on the source (Extract). Should you wish to perform DDL and DML replication from your source database, the DDL part must be explicitly configured through a single DDL parameter statement.
GoldenGate does not support DDL only replication. DDL replication must accompany DML replication and is enabled or disabled via the GETTRUNCATES and IGNORETRUNCATES parameters respectively.
DDL replication is configured and enabled on the Extract and Replicat process by passing multiple options to the DDL parameter. Not only can DDL operations be filtered for specific schemas and objects, but also operation types. The filtering is essentially driven through both the MAP statement and the use of wildcards in the configuration options.
Starting with wildcards, the following DDL parameter statement...
Change the font size
Change margin width
Change background colour