Because there are alot of bugs in how Oracle implements materialized views. They are extremely unstable and unpredictable. For instance, try querying a materialized view while it's in the middle of refresh.
btw. Ian, in Oracle 8 they were called snapshots. -Adam On 9/1/05, Tanguy Rademakers <[EMAIL PROTECTED]> wrote: > >Again, I really don't recommend using Oracle built-in materialized > >views. You should create the tables manually instead. > > I don't agree. Putting aside issues of making your program database > independent, which, if i read this thread correctly, aren't present here, why > would you spend time duplicating a functionality that your database already > provides? > > /t > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217164 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
