Dedicated server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andre L - 30 Jun 2005 14:46 GMT

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?

Reply to this Message

IANAL_VISTA - 30 Jun 2005 15:00 GMT

> Hi
>
[quoted text clipped - 3 lines]
> 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.

Reply to this Message