(Simon Greener) I will edit this over the next few weeks but I have been doing quite a bit of work on FAST REFRESHing of materialized views based on tables with SDO_Geometries.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help