How to update Materialized View after changing Primary Key of Master Table on HOST
In HOST DB, I added 1 column to an existing table and added it to its Primary key.
In Branch DB, whose database link points to HOST, I added that column in materialized view table.
Would like to know how to edit materialized view to add new column, as while doing so it gives error saying:
"ORA-23412: Master table's primary key columns have changed"
Thanks
Niti