Re: Unable to refresh materialized view under a particular instance

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 07 Sep 2005 08:44:36 -0700
Message-ID: <1126107825.301572@yasure>

Tan Chan Kai wrote:
> I checked this instance against another working scheme. What I noticed
> was that there were a few packages under SYS listed as Invalid compared
> to the working one which has all packages under SYS listed as Valid.
> Could this be part of the problem?

It could be but even if it isn't they should be compiled.

Equally important you are running on a version of Oracle, 8.1.7.0, currently in desupport. At the very least you should patch to 8.1.7.4.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Wed Sep 07 2005 - 10:44:36 CDT