Snapshot/materialized view. Are they supported?

[alovas]

Hi,

Are snapshots (materialized views) supported in PLSQL/Developer? I see them just under tables and when I compare two databases one with a snapshot the other without it then in differences I see that PLSQL/Developer will create just a simple table, not a snapshot. Is it an error?

 

[Marco Kalter]

There is no explicit support for materialized views. This will be added in 6.0 early next year.

 

[ayurchen]

Hi!

Are there plans to support materialized view?

Thank you.

 

[Marco Kalter]

They are already supported. There is a "Materialized views" folder in the Object Browser.