Wonderful...thanks, Jared... Preparing to do just that(prepare a test environment and test scenario).... Did you experience any "gotchas".... Thanks... ________________________________ From: Jared Still [mailto:jkstill@xxxxxxxxx] Sent: Wednesday, June 02, 2010 2:39 PM To: Chuck Boddy Cc: oracle-l Subject: Re: Materialized views on 10g database reading log tables on 9i database On Wed, Jun 2, 2010 at 1:35 PM, Chuck Boddy <Chuck.Boddy@xxxxxxxxxxxxxxx> wrote: Hi, Can Materialized Views on a 10g database(fast refresh) read from log tables on a 9i database? Thanks I've had 10g doing fast refreshes from 9i, and currently have 11gR1 doing fast refreshes from 10gR2. Though of course the best course of action is to test in your own environment. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com