Database DataWarehousing (MOSC)

MOSC Banner

Materialized View on a Prebuilt Table

edited Aug 1, 2010 9:49PM in Database DataWarehousing (MOSC) 1 commentAnswered
Question on a Materialized view that is on a Prebuilt table. When you are refreshing the Materialized view is the data that is in the Prebuilt table available for query
until the refresh completes.  I would know that as the refresh is finishing and the table is being populated it would not be available but in the event that the refresh takes a while, would the data be available in this situation where it is on a prebuilt table.

Thanks
greG

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