Database DataWarehousing (MOSC)

MOSC Banner

MV Creates but does not populate?

edited Sep 7, 2020 6:49PM in Database DataWarehousing (MOSC) 6 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center