Loading...

Follow Hemant's Oracle DBA Blog on Feedspot

Continue with Google
Continue with Facebook
or

Valid
In my previous blog post, I've shown a Materialized View that is built as an empty MV and subsequently populated by a Refresh call.You can ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
A Materialized View can be created with all the target rows pre-inserted (and subsequently refreshed for changes).  This is the default ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
So far, in previous posts in this series, I have demonstrated Materialized Views that set to REFRESH ON DEMAND.You can also define a ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
So far, all my blog posts in this series cover "single" Materialized Views (even if I have created two MVs, they are independent of each ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Till 9i, if you did a COMPLETE Refresh of a Single Materialized View, Oracle would do a TRUNCATE followed by an INSERT.If you did a ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
In the previous blog post, I had a remark "We'll explore the implications of "REFRESH FAST" and just "REFRESH" alone in a subsequent blog ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Now that we have two Materialized Views against a Source table, how can we identify the relationship via the data dictionary ?This is the ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
You can define multiple Materialized Views against the same Source Table with differences in :a) the SELECT clause column listb) ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Continuing the previous post, what happens when there is an UPDATE to the source table ?SQL> select * from source_table; ID ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
A series of posts in 2017 on 12cR1 RAC :1.  1. Grid  Infrastructure Install  (Dec-16)2.  2. Convert AdminManaged Database to ..read more

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview