** MVs source 8i to 9i
From: A Joshi <ajoshi977_at_yahoo.com>
Date: Tue, 21 Jul 2009 09:26:59 -0700 (PDT)
Message-ID: <361911.16455.qm_at_web57505.mail.re1.yahoo.com>
Hi,
Date: Tue, 21 Jul 2009 09:26:59 -0700 (PDT)
Message-ID: <361911.16455.qm_at_web57505.mail.re1.yahoo.com>
Hi,
I have a 9i database and it has some MVs that go to a source database which is on 8i. This source database is planned to be upgraded from 8i to 9i. Do I need to drop and create the MVs with this upgrade. I would like to avoid a drop/create and I am thinking as long as refresh after the upgrade works : it is fine. Is a complete refresh needed? Any comments or experiences? Thanks for help.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 21 2009 - 11:26:59 CDT