Re: Oracle Upgrade Concerns

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 23 Jun 2006 12:38:27 -0700
Message-ID: <1151091507.776399.315700@m73g2000cwd.googlegroups.com>

art_at_chicagorsvp.com wrote:
> We are running on AIX 64, 5L.......however, this is the first time I
> have seen this ORA-0600. I do not remember seeing it before during
> other test upgrades with this patchset. Of course, I could have missed
> it. We are going to restore the server and try it again and see if the
> same thing happen.
>
> One thing that is consistant is the INVALID status of all Materialized
> Views. Any idea why??

Well possibly a bug in the patchset for your platform? Researching things like that is why you can use metalink yourself or use oracle support.

You didn't respond earlier but these are materialized views for your application that you are running right? Did you create them yourself or are they part of a package.

If you created them at your place you may have to dig in and find out why they are invalid. There are lots of hints about checking materialized views at http://asktom.oracle.com ...

If they belong to a package then you can work with the package vendor. Received on Fri Jun 23 2006 - 14:38:27 CDT