MV Creates but does not populate?
Hi - We are still on Oracle 11.2.0.4.
Setup: I created five MV's one for each table needed for a report generator.
Each MV has one base table and one MV log.
They are refreshed via ON COMMIT with PRIMARY_KEY as they are local to the base tables.
Their status is REFRESHED
Next I created an MV to be used by the application to query the five MV's
This MV is created without a log due to it being an AGGREGATE MV (multiple base tables - MV's).
Also, it is created with a pre-scheduled REFRESH due to it not having a log.