Re: ** MVs source 8i to 9i
Date: Tue, 21 Jul 2009 11:35:40 -0500
Have you tested this at all? (might be a good idea).I know that when I migrated a large MVIEW site from 7.3.4 to 8i, I had to complete refresh all FAST mviews , but I believe that was due to the ROWID structure change introduced in 8i (and I wanted to switch to PK mviews where appropriate). Baring those issues, I would think you'd be fine. I'd at least try and test it out prior to doing production.
"Next to doing a good job yourself,
the greatest joy is in having someone else do a first-class job under your direction."
- William Feather
On Tue, Jul 21, 2009 at 11:26 AM, A Joshi <ajoshi977_at_yahoo.com> wrote:
> 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.