[inkyoto]

This is where Oracle has a upper hand in the materialised view department: a materialised view can be refreshed either manually or automatically, with both, incremental and full, refresh options being available.

[DerArzt]

Yeah, but then you're using Oracle.