Why not mviews with fast refresh? Maybe logical standby?