Re: Materialized Views

"The Magnet" <art_at_unsu.com> a écrit dans le message de news: 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?

Because the optimizer generates intermediate memory views and unfortunatly (and bugly) it generates trwice the same name.

Regards
Michel Received on Thu Apr 15 2010 - 12:36:47 CDT