Tables VS Materialized Views

[null0000]

In version 9.0.6.1665 as well as in all Beta 10 materialized views and tables are combined under the folder "Tables" in Object browser. In addition, materialized views are placed in other folder "Materialized views". Seems that such behavior is incorrect.
If materialized views and tables are combined in 1 folder, which is debatable fact by itself, then "right mouse click" should provide properties for both types of objects , which is not happening. AND materialized views should not be placed in separate folder additionally.
if materialized views are placed in separate folder, then they should not be in "Tables".

So, please either filter out materialized views when you query user_tables or get their properties.

 

[Marco Kalter]

The Tables folder shows the underlying table of the materialized view.

 

[Bernhard S]

I think it's a bug that materialized views are not part of "Compare User Objects". If you have different materialized view definitions on source and target session, PL/SQL Developer won't recognize the difference! It will only see the difference on the materialized view table, if there is any at all. In cases where the different materialized view definitions don't result in a different structure on the materialized view table, i.e. by using different where clauses, PL/SQL Developer won't recognize any difference.