Was just looking at the DDL of a materialized view on a dev database that I need to recreate on a prod database.
The view has a log, but when I look at the logs DDL I see it is not referencing the source table, (which is a view over a dblink) but the actual materialized view itself.
I know little about MV's, but I understood the log was supposed to reference the source table (or view, in this case)
So to recreate this on the prod database, I was going to just copy paste the DDL to a SQL command window - but I thought you would create the log first, then the materialized view, however in this case creating the log would likely fail because the materialized view doesn't exist yet.
So do I just create the materialized view first, then the log? Or is this particular materialized view not correctly built in the first place?
thanks