Materialized Views
From: The Magnet <art_at_unsu.com>
Date: Thu, 15 Apr 2010 10:33:17 -0700 (PDT)
Message-ID: <059a76ea-1b9d-486d-bd56-ae3857f9b893_at_w17g2000yqj.googlegroups.com>
Date: Thu, 15 Apr 2010 10:33:17 -0700 (PDT)
Message-ID: <059a76ea-1b9d-486d-bd56-ae3857f9b893_at_w17g2000yqj.googlegroups.com>
We're about at the end of our rope. We have a script that runs at night and re-created some materialized view. The SQL simple drops the view and re-creates it.
However, each night a different view fails to be created. The view is dropped, but when attempting we'll get a ORA-00955:
FROM analyst a, broker b, master_table m, (
*
ERROR at line 14:
ORA-00955: name is already used by an existing object
How can you get that error on a SELECT?? And, it is different every time. I thought is was timing, but that is not it.
Suggestions? Received on Thu Apr 15 2010 - 12:33:17 CDT