Materialized Views in an Active Standby Pair

When you replicate a database containing a materialized or non-materialized view, only the detail tables associated with the view are replicated. The view itself is not replicated.

A matching view can be defined on the standby database, but it is not required. If detail tables are replicated, TimesTen Classic automatically updates the corresponding view. However, TimesTen Classic replication verifies only that the replicated detail tables have the same structure on both databases. It does not enforce that the materialized views are the same on each database.