Data Replication
- Data Replication 9.7.0
- All Products
Then replicate the following statements in the second cycle:CREATE TABLE test (col1 NUMBER NOT NULL, col2 NUMBER NULL); INSERT INTO test (col1, col2) VALUES (1, NULL); COMMIT;
In the second cycle, the Applier first replicates the ALTER TABLE operation but fails to set the NOT NULL constraint for the column that stores the NULL value.UPDATE tst SET col2 = 0 WHERE col1 = 1; COMMIT; ALTER TABLE tst MODIFY (col2 NOT NULL);