Materialized Views

HELP Please!

Have added two columns to the master table and each of the 3 million rows have new info in one of the two new columns. If I look at the materialized view log on the master I see my two new columns. So, I have done nothing to this MV Log.

On the replication server I have a materialized view that needs updated to reflect these two new columns. It appears I can't issue 'alter materialized view''.

Here is what I am planning to do:

1. Drop the materialized view on the rep server (which will also remove the table???)
2. Re-Create the materialized view on the rep server adding these two new columns in the select statement, along with a where clause to limit the replication to about 1million rows. 3)Re-Create the table 4)Re-Create the indexes 5)Do the refresh

Any thoughts would be greatly appreciated. Received on Mon Jan 15 2007 - 15:51:38 CST