The Last DDL Date and Time on top of the Schema Browser (right side) does not get refreshed after refreshing a snapshot \ Materialized view.
Steps to Replicate:
1) Select a materialized view under the snapshots tab in the Schema browser.
2) Right-click on the materialized view an choose to Refresh.
3) Last DDL Date and Time on top of the schema browser (right side) do not get refreshed.
4) Now double-click on the materialized view.
5) Under default tab, Basic Info you will find Last Refresh Last Date and the time and date.
6) Now compare this information to the one displayed , it is NOT the same.
WORKAROUND:
Steps to help view the correct Last DDL
1) You can double-click on the material view. Use the Basic information tab - the correct Last DDL will appear.
OR
2) Most convenient. You can right-click materialized View and check Last Refresh. You will receive a new column with the Last DDL time refreshed, next to the materialized view . Please see the screenshot below.
STATUS:
Waiting for fix in a future release of Toad for Oracle.
