Home » Server Options » Replication » when going for materialised views (oracle 10g)
when going for materialised views [message #426551] Fri, 16 October 2009 08:09
Messages: 134
Registered: August 2007
Location: Mauritius
Senior Member

I am considering opting for a materialised view setup to cater for a great number of reports that extract their data from a transaction processing / general purpose database. Volumes to be processed can be quite bulky with many table joins. I was thinking if it were worthwhile creating the materialised views in a tablespace other than the one where the source tables are sitting?
This might sound trivial but i'm a newbie at using materialised views and still considering the options.

Previous Topic: DML from trigger not propagated
Next Topic: which soln is best for data propogation from master to app DB?
Goto Forum:

Current Time: Mon Aug 15 02:07:58 CDT 2022