-
Title
To activate Tables with Compressed Partition in Oracle 10g -
Description
In SharePlex Version 7.6.3 and above activating the config file does not add in the Tables that contain compressed partitions.
SharePlex for Oracle does not support Table Compresssion for Oracle 10g. To bypass this need a workaround ?
-
Cause
New logic has been added to prevent 10g Compressed Tables to be added to SharePlex Replication.
-
Resolution
Workaround:
In the config file, you can add the table with compressed partition with the syntax below:
SCHEMA.SOURCE !allow_invalid_type SCHEMA.TARGET <route>
Then activate config again
After successfull activation the table will be added into the SharePlex replication.
Run "view config <config_file> to confirm that the table is added into the SharePlex replication.
Note: Data is not replicated for this Table for Compressed Partitions.