You can filter the objects for which DDL is replicated when the SP_OCT_REPLICATE_ALL_DDL parameter is enabled. This is the DDL that is not in the replication configuration.

Note: DDL filtering is only allowed for objects outside the replication configuration. All DDL performed on objects inside the replication configuration must be replicated to keep the source and target metadata consistent so that DML succeeds.

DDL filtering is controlled in the SHAREPLEX_DDL_CONTROL table that is installed in the SharePlex schema.

Name	Type
-------------	------------
DDL_PARAMETER	NUMBER
DDL_CODE	NUMBER
SCHEMA_FILTER	VARCHAR2(32)
OBJECT_FILTER	VARCHAR2(32)

Each row in the SHAREPLEX_DDL_CONTROL table defines a filter based on what you specify in each of the following columns:

• SCHEMA_FILTER filters DDL by a schema name.

• OBJECT_FILTER filters DDL by an object name.
• DDL_CODE filters by the code number of a DDL type. See DDL codes.

A null value in the DDL_CODE column means that the filter applies to all of the DDL types A null in the SCHEMA_FILTER or OBJECT_FILTER column means that the filter applies to any schema or object name.

Note: The DDL_PARAMETER column is not an active column as of this release of SharePlex.

To filter DDL:

Insert a row into the table with the desired values in the active columns.

Examples

The following filters out of replication the DDL for ALTER TABLE:

INSERT INTO SPLEX.SHAREPLEX_DDL_CONTROL (DDL_CODE, SCHEMA_FILTER, OBJECT_FILTER) values (15,null,null);

The following filters out of replication all DDL for all objects with names that begin with TEST_ in any schema:

INSERT INTO SPLEX.SHAREPLEX_DDL_CONTROL (DDL_CODE, SCHEMA_FILTER, OBJECT_FILTER) values (null,null,'TEST_%');

The following filters out of replication the DDL for CREATE TABLE for the "Sales" schema and objects with names that begin with "TEST_":

INSERT INTO SPLEX.SHAREPLEX_DDL_CONTROL (DDL_CODE, SCHEMA_FILTER, OBJECT_FILTER) values (1,'Sales','TEST_%');

DDL codes

DDL Type	DDL_CODE
CREATE TABLE	1
ALTER TABLE	15
DROP TABLE	12
ASSOCIATE STATISTICS	168
DISASSOCIATE STATISTICS	169
COMMENT TABLE, COMMENT ON COLUMNS	29
TRUNCATE	85
CREATE INDEX	9
ALTER INDEX	11
DROP INDEX	10
CREATE SEQUENCE	13
ALTER SEQUENCE	14
DROP SEQUENCE	16
CREATE CLUSTER	4
DROP CLUSTER	8
CREATE USER	51
ALTER USER	43
DROP USER	53
CREATE_ROLE	52
ALTER_ROLE	79
DROP_ROLE	54
GRANT	17
REVOKE	18
CREATE SYNONYM	19
DROP SYNONYM	20
CREATE VIEW	21
ALTER VIEW	88
DROP VIEW	22
CREATE TYPE	77
ALTER TYPE	80
DROP TYPE	78
CREATE TYPE BODY	81
DROP TYPE BODY	83
CREATE FUNCTION	91
ALTER FUNCTION	92
DROP FUNCTION	93
CREATE PROCEDURE	24
ALTER PROCEDURE	25
DROP PROCEDURE	68
CREATE PACKAGE	94
ALTER PACKAGE	95
DROP PACKAGE	96
CREATE PACKAGE BODY	97
ALTER PACKAGE BODY	98
DROP PACKAGE BODY	99
CREATE DIRECTORY	157
DROP DIRECTORY	158