Re: Dedicated server

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Thu, 30 Jun 2005 14:00:57 GMT
Message-ID: <Xns9685475EDA973SunnySD@68.6.19.6>

"Andre L via DBMonster.com" <forum_at_DBMonster.com> wrote in news:509F44A0B7180_at_DBMonster.com:

> Hi
>
> I have an app server with 2 tnsnames connections to my Oracle 8.1.7
> db, one set up for dedicated server (server=dedicated) and the other
> not. Running a particular query using the dedicated server conn gives
> ORA-03232 but the same query, same user, using the 'non dedicated'
> conn is ok. Why?
>

32320, 00000, "REFRESH FAST of \"%s\".\"%s\" unsupported after container table PMOPs"
// *Cause: A Partition Maintenance Operation (PMOP) has been performed on the

//          materialized view, and no materialized view supports
//          fast refersh after container table PMOPs.
// *Action: Use REFRESH COMPLETE.  Note: you can determine why your 
//          materialized view does not support fast refresh after PMOPs 
using
//          the DBMS_MVIEW.EXPLAIN_MVIEW() API.

That being said, I'd suspect that it is a bug. Received on Thu Jun 30 2005 - 09:00:57 CDT