Database DataWarehousing (MOSC)

MOSC Banner

How to update Materialized View after changing Primary Key of Master Table on HOST

edited Apr 24, 2013 12:05AM in Database DataWarehousing (MOSC) 6 commentsAnswered
Hi,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center