You can configure SharePlex to filter out the following DML from replication when wildcarding is being used.
You can configure SharePlex to filter any type of DML operation so that the operation is not replicated to the target table. DML filtering is compatible with most other SharePlex configuration syntax. See the Restrictions.
To configure a DML filter, add the following syntax to the source table specification. Leave a space between the table specification and the filter specification. You can specify multiple operation types to filter. Any additional syntax for other features, such as a column list or key definition, must follow the DML filter specification.
!dml(DML_type[,DML_type][,...])
Where DML_type is one of the following:
DML_type input | Operation type |
---|---|
i | INSERT |
d | DELETE |
u | UPDATE |
Example 1
The following example filters DELETE operations from being replicated to the target table.
Datasource:o.ora |
|
|
scott.emp !dml(d) |
scott.emp |
prodsys@o.sysdb |
Example 2
The following example filters DELETEs and INSERTs so that only UPDATEs are replicated to the target table. This example also shows how a DML filter is compatible with a column mapping specification.
Datasource:o.ora |
|
|
scott.stock !dml(d,i) (ID, name) |
scott.stock (SKU, prod) |
sys2@o.sysdb |
Use the verify config command to view the DML that is being filtered for each table in the configuration file. This command can be used for an active or inactive configuration file.
sp_ctrl> verify config myconfig
7: "SCOTT"."EMP" "SCOTT"."EMP" prodsys@o.proddb
Filter out >>>>> DELETES
Unique Key : (EMPLOYEE_ID)
You can prevent SharePlex from replicating sequences, materialized views, and SQL*Loader direct-path loads. By default the replication of these objects is enabled.
Filter out this object | Set this parameter | Value |
---|---|---|
Sequences | SP_OCT_REPLICATE_SEQUENCES | 0 |
Materialized Views | SP_OCT_REPLICATE_MVIEW | 0 |
SQL*Loader direct-path loads | SP_OCT_REPLICATE_DLOAD | 0 |
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy