Unable to refresh materialized view under a particular instance

From: <tanchankai_at_gmail.com>
Date: 6 Sep 2005 18:20:08 -0700
Message-ID: <1126056008.721497.315030@g14g2000cwa.googlegroups.com>

Have an Oracle 8.1.7.0 database running multiple instances. The problem is that for one of the instance, any schema is unable to refresh materialized views. When trying to do a complete refresh for any materialized view for any schema, Oracle returns with the following errors:

*
ERROR at line 1:

ORA-04045: errors during recompilation/revalidation of SYS.DBMS_UTILITY
ORA-01406: fetched column value was truncated
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 653
ORA-06512: at line 1

There was no problem creating the materialized view in the first place. It's only when refreshing it does the error appear. No problem performing refreshes on the other instances though, so I suspect it's an instance thing.

Would appreciate input to help try resolving this problem. TIA for any help/comments. Received on Tue Sep 06 2005 - 20:20:08 CDT