Re: ** MVs source 8i to 9i
From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Tue, 21 Jul 2009 11:35:40 -0500
Message-ID: <e9569ef30907210935h772fb8c9l1ffdb7f5afff88ef_at_mail.gmail.com>
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.
Date: Tue, 21 Jul 2009 11:35:40 -0500
Message-ID: <e9569ef30907210935h772fb8c9l1ffdb7f5afff88ef_at_mail.gmail.com>
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.
Bradd Piontek
"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:
> 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:35:40 CDT