When 'Alter table exchange partition' is issued on the Source, how does replication work?
1. Issue Alter table exchange partition on Source and the Target.
2. Activate the config on the Source with the new table.
Here is an Example:
Both Source and Target:
1. CREATE TABLE anu.invoices
(no NUMBER NOT NULL,
comments VARCHAR2(500))
PARTITION BY RANGE (no)
(PARTITION no_q1 VALUES LESS THAN (500) TABLESPACE users,
PARTITION no_q2 VALUES LESS THAN (1000) TABLESPACE users,
PARTITION no_q3 VALUES LESS THAN (1500) TABLESPACE users,
PARTITION no_q4 VALUES LESS THAN (2000) TABLESPACE users);
2. Activate the config with the above table in replication. Replication is fine.
3. On both Source and Target:
create table anu.tab_q2
(no NUMBER NOT NULL,
comments VARCHAR2(500))
4. ALTER TABLE anu.invoices
EXCHANGE PARTITION no_q2 WITH TABLE anu.tab_q2
5. Copy current active configuration to a new file on the Source and add the table tab_q2 to the config.
6. Activate config for the new file.
7. Now tables tab_q2 and invoices replicate fine.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy