Initial Synchronization
To configure DDL replication, start with a target database that is synchronized with the source database. DDL support is compatible with the Replicat initial load method.
Before executing an initial load, disable DDL extraction and replication. DDL processing is controlled by the DDL parameter in the Extract and Replicat parameter files.
After initial synchronization of the source and target data, use all of the source sequence values at least once with NEXTVAL
before you run the source applications. You can use a script that selects NEXTVAL
from every sequence in the system. This must be done while Extract is running.