Re: Materialized Views
From: joel garry <joel-garry_at_home.com>
Date: Tue, 12 Jan 2010 15:43:15 -0800 (PST)
Message-ID: <2d9d7a5c-4d5c-4d8a-bbfc-225fa471207e_at_u41g2000yqe.googlegroups.com>
On Jan 12, 1:51 pm, Mladen Gogala <n..._at_email.here.invalid> wrote:
> On Tue, 12 Jan 2010 12:35:52 -0800, The Magnet wrote:
> > Yes, I know what the error is. But what conditions? How simple can it
> > get? A select statement with no joins, no referential constraints, a
> > primary key, no indexes. It is only over a DB link. So, what is so
> > complex?
>
> It doesn't matter what's complicated or is not complicated. The errors
> tells you all that you need to know: Do not use ON COMMIT. There are non-
> fixed bugs and it doesn't work. Period. A bug that is present since the
> version 8i is described in the Metastink id: 1385495.8
>
> BTW, speaking of the Metastink, did you notice that sometimes the normal
> navigation keys do not work like they're expected?
>
> --http://mgogala.byethost5.com
Date: Tue, 12 Jan 2010 15:43:15 -0800 (PST)
Message-ID: <2d9d7a5c-4d5c-4d8a-bbfc-225fa471207e_at_u41g2000yqe.googlegroups.com>
On Jan 12, 1:51 pm, Mladen Gogala <n..._at_email.here.invalid> wrote:
> On Tue, 12 Jan 2010 12:35:52 -0800, The Magnet wrote:
> > Yes, I know what the error is. But what conditions? How simple can it
> > get? A select statement with no joins, no referential constraints, a
> > primary key, no indexes. It is only over a DB link. So, what is so
> > complex?
>
> It doesn't matter what's complicated or is not complicated. The errors
> tells you all that you need to know: Do not use ON COMMIT. There are non-
> fixed bugs and it doesn't work. Period. A bug that is present since the
> version 8i is described in the Metastink id: 1385495.8
>
> BTW, speaking of the Metastink, did you notice that sometimes the normal
> navigation keys do not work like they're expected?
>
> --http://mgogala.byethost5.com
It is no longer Metastink. It's new name is Mostly Offal Sausage.
For those who wouldn't know, Hans' blog is giving constructive suggestions for Oracle to improve MOS navigation. http://hansforbrich.blogspot.com/
jg
-- _at_home.com is bogus. View from the train this morning looked like Hawaii 5-0 http://www.signonsandiego.com/photos/2010/jan/11/97857/Received on Tue Jan 12 2010 - 17:43:15 CST