Pages

Wednesday, November 20, 2019

ORA-23412: master table's primary key columns have changed

On Snapshot DB  - try I:
DROP MATERIALIZED VIEW MY_VIEW_SS
CREATE MATERIALIZED VIEW MY_VIEW_SS
REFRESH FAST ON DEMAND
NEXT NULL
AS
SELECT merge_network_id, item_id, active_ind
FROM MY_VIEW_SS@TOMASTER;


CREATE MATERIALIZED VIEW MY_VIEW_SS
*
ERROR at line 1:
ORA-23412: master table's primary key columns have changed


On Master DB:
DROP MATERIALIZED VIEW LOG ON MY_VIEW_SS; 
CREATE MATERIALIZED VIEW LOG ON MY_VIEW_SS TABLESPACE IGT_TABLE;

On Snapshot DB - try II:
CREATE MATERIALIZED VIEW MY_VIEW_SS
REFRESH FAST ON DEMAND
NEXT NULL
AS
SELECT merge_network_id, item_id, active_ind
FROM MY_VIEW_SS@MASTER;

Done