ORA-30332: container table already in use by other summary ?

From: Ian White <ian_p_white_at_hotmail.com>
Date: 16 Aug 2001 01:43:49 -0700
Message-ID: <a55f2d08.0108160043.2e603cdd@posting.google.com>

Hi,

I've got a datawarehouse on 8.1.6 with materalized views sitting on top of prebuilt tables.

To update the summary tables (several times a day) , it is necessary to drop the mviews , update the prebuilt tables, and put the snapshot back on.

Occasionally we get this error message which stops us from putting the view back on top.

---

CREATE MATERIALIZED VIEW EQSTAR.SM1_ALL
*
ERROR at line 1:
ORA-30332: container table already in use by other summary

---

Once this occurs , there appears to be no option but to drop the underlying table (all partitioned) , and rebuilted it from fresh. However this results in the system being unavailable for several hours.

From other problems in this area , it would appear that occasionally some system table flags are not reset on the drop , and oracle still believes that there is a prebuilt view on the table already , even though it doesn't exist to drop.

Any one got a solution to this one.

Ian Received on Thu Aug 16 2001 - 03:43:49 CDT