How to specify table exclusion in the configuration
The exclusion list follows the table specification and is indicated by the keyword not. The following sample configuration entry:
expand scott.prod% not (%temp%) hal.% sysa@o.sidb
Will cause SharePlex to activate all tables owned by “SCOTT”, where the table_name is like “PROD%” and the table_name is not like “%TEMP%”. All the tables that match this description will be replicated to the same table_name on the target, owned by HAL
