DDLReplicationAction

Determines whether a table or a sequence is included in an active standby pair replication scheme when created.

The table can be included if the DDLReplicationLevel connection attribute is set to 2 or 3. The sequence can be included if the DDLReplicationLevel connection attribute is set to 3.

Replication of DDL operations is enabled (with restrictions) by the set value of the DDLReplicationLevel connection attribute. For more details, see DDLReplicationLevel.

The value can be modified by an ALTER SESSION SQL statement, described in Oracle TimesTen In-Memory Database SQL Reference. For example:

ALTER SESSION SET DDL_REPLICATION_ACTION='EXCLUDE';

Values set by ALTER SESSION override the value set by this attribute.

For examples of altering an active standby pair, see Altering an Active Standby Pair in the Oracle TimesTen In-Memory Database Replication Guide.

DDL operations are automatically committed. When RETURN TWOSAFE has been specified, errors and timeouts may occur as described in RETURN TWOSAFE in the Oracle TimesTen In-Memory Database Replication Guide. If a RETURN TWOSAFE timeout occurs, the DDL transaction is committed locally regardless of the LOCAL COMMIT ACTION that has been specified.

To learn more about replicating DDL, see Making DDL Changes in an Active Standby Pair in the Oracle TimesTen In-Memory Database Replication Guide.

Required Privilege

ADMIN privilege is required if the value of this attribute is INCLUDE.

Usage in TimesTen Scaleout and TimesTen Classic

This attribute is supported in TimesTen Classic but not supported in TimesTen Scaleout.

Setting

Set DDLReplicationAction as follows:

Where to set the attribute	How the attribute is represented	Setting
C or Java programs or UNIX and Linux systems odbc.ini file in TimesTen Classic	DDLReplicationAction	INCLUDE (default) - When a table or sequence is created, it is automatically added to the active standby pair scheme when the appropriate DDLReplicationLevel value is configured. EXCLUDE - When a table or sequence is created, it is not automatically included in the active standby pair.
Windows ODBC Data Source Administrator	Not applicable