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;
*
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