Monday, June 24, 2013
SQL Error: ORA-23412: master table's primary key columns have changed
Got this beautiful error when trying to re-create one of our Materialized views (MV). Sadly googling did not seem to provide a solution. To fix this I had to drop the MV log on the 'parent' database for the table in question. I could then re-create the MV.
Subscribe to:
Post Comments (Atom)
1 comment:
Thanks for posting this, I found your post via a Google search and it proved helpful to me in resolving the same error in my data warehouse this morning. Just wanted to send a note of thanks.
-Andy Hedin
Post a Comment