8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Real-Time Materialized Views in Oracle Database 12c Release 2 (12.2)


Stewart Bryson said...

Analytic functions seem to be a limitation in many, though not all, MV features. Any idea about rewritability of what moving window functions functions?

Tim... said...

Hi.

As per DM chat, but here for others to read... You can't fast refresh a MView containing an analytic function, so by definition you can't make it real-time, since the MView must be able to fast rewrite to use this functionality... :)

Cheers

Tim...

Ramniwas Chaurasia said...

Hi. It's a nice article. However, it would be useful if you can mention that the real-time mviews do not work in distributed databases using DB links under "Restriction" category.

Thanks!

Tim... said...

Hi.

I'll add it, but I feel this is a little redundant. IMHO the nature of what it is doing doesn't really make sense over a database link.

Cheers

Tim...

Batu said...

With 2 or more base tables it is not working. Still requires MV refreshment.
Is there someone tried it with 2 more tables?

Tim... said...

Hi.

All base tables have to have valid materialized views, and the mview needs to be capable of a fast refresh. If those are in place it should be fine.

Cheers

Tim...

Chuck said...

Is there any way to make these usable (no ORA-28113) on VPD policy protected tables? I know I can make a mview per "customer" and a VPD a view to glue them together, but do the logs and real-time really work? I've avoided mlogs in VPD in earlier releases just because I cannot find documentation detailing how they behave. Now I'm intrigued a bit more.

Tim... said...

Hi.

According to the docs, the MView should use USING TRUSTED CONSTRAINTS if it is against a VPD base table. I guess you would need a separate VPD policy on the resulting MView, but I'm not sure if real-time MViews can cope with that. Probably a question for an SR on MOS I guess.

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.