1. Oracle GoldenGate Classic Documentation
  2. Administer
  3. Data Management
  4. Oracle: DDL Replication
  5. Configuring DDL Support
  6. Using DDL String Substitution

Using DDL String Substitution

You can substitute strings within a DDL operation while it is being processed by Oracle GoldenGate.

This feature provides a convenience for changing and mapping directory names, comments, and other things that are not directly related to data structures. For example, you could substitute one tablespace name for another, or substitute a string within comments. String substitution is controlled by the DDLSUBST parameter. For more information, see Reference for Oracle GoldenGate.

Note:

Before you create a DDLSUBST parameter statement, it might help to review How DDL is Evaluated for Processing in this chapter.