Can you increase the size of the column "route" in the shareplex_partition table when using horizontal partitioning
There are mutiple targets where horizontally partitioned data needs to go to. Size of route gets really big.
Route used in horizontally partitioned replication has a limitation of 1024 characters.
Resolution:
To use a route size greater than 1024 characters follow the steps below.
1) For rthe same scheme name, add another line in the config file with the new route.
2) Add the additional row for the same scheme name and new route to the shareplex_partition table
Here is an example
CREATE TABLE DEMO_SRC
(
NAME VARCHAR2(30 BYTE),
ADDRESS VARCHAR2(60 BYTE),
PHONE# VARCHAR2(12 BYTE),
COL1 VARCHAR2(12 BYTE)
)
sp_ctrl (irvsupu1:8000)> view config test2
datasource:o.hd920
#source tables target tables routing map
scott.demo_src scott.demo_src !scheme1
! irvsupu1:queue1*irvsupu1@o.hd920+ irvsupu1:queue2*irvsupu2@o.hd920+ irvsupu1:queue3*irvsupu3@o.hd920
*(assume the above line is > 1024characters and you want to add another route, instead of appending it to the above line you can add aanother line down here)
! irvsupu1:queue10*irvsupu10@o.hd920
Â
SQL> 1 select partition_scheme, route,col_conditions from splex.shareplex_partition
SQL> /
PARTITIO ROUTE COL_CONDITIONS
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
scheme1 irvsupu1:queue1*irvsupu1@o.hd920+ irvsupu1:queue2*irvsupu2@o.hd920+ irvsupu1:queue3*irvsupu3@o.hd920 col1 >1000
For the new line added to the configuration file insert another line as follows
sqlplus>insert into splex.shareplex_partition(partition_scheme, route,col_conditions) values ( "sheme1","irvsupu1:queue1*irvsupu10@o.hd920","col1 >1000"
sqlplus>commit
