shareplex does not support certain datatype in horizontal partition for example: LOB, ARRAY, IOT table.
The below are tests' output which show lob colums will have empty data if the table is configured as a SharePlex Horizontal Partitioning table.
======= SharePlex Horizontal Partitioning ===========
SOURCE:
SQL> insert into TEST_CT_PRODUCT_SEARCH_NEW values(1,1,lpad('X',4000,'X'),1295341382,1,1,1,1,1,1,1,1,1,1,1);
1 row created.
SQL> commit;
Commit complete.
SQL> select PROD_REFERENCE_ID,INDEX_MESSAGE from TEST_CT_PRODUCT_SEARCH_NEW;
PROD_REFERENCE_ID
-----------------
INDEX_MESSAGE
--------------------------------------------------------------------------------
1
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
TARGET:
SQL> select PROD_REFERENCE_ID,INDEX_MESSAGE from TEST_CT_PRODUCT_SEARCH_INDEX;
PROD_REFERENCE_ID
-----------------
INDEX_MESSAGE
--------------------------------------------------------------------------------
1
(EMPTY LOB COLUMN)
=========== Not In SharePlex Horizontal Partitioning =================
SOURCE:
SQL> insert into TEST_CT_PRODUCT_SEARCH_NEW2 values(1,1,lpad('X',4000,'X'),1295341382,1,1,1,1,1,1,1,1,1,1,1);
1 row created.
SQL> commit;
Commit complete.
SQL> select PROD_REFERENCE_ID,INDEX_MESSAGE from TEST_CT_PRODUCT_SEARCH_NEW2;
PROD_REFERENCE_ID
-----------------
INDEX_MESSAGE
--------------------------------------------------------------------------------
1
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
<