Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

materialized view (log) question

GlenStromApr 9 2014 — edited Apr 10 2014

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 8 2014
Added on Apr 9 2014
13 comments
940 views