...
- According to the Oracle 10G documentation, the mviews we are creating are "simple join mviewsMaterialized Views with Joins Only" and should be eligible for fast refresh. I will be reformulating the mview and view definitions to use rowid based logs and mviews with rowid columns based on information from this page: http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14223/basicmv.htm#i1006803
...