Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: On commit refresh gives ORA-12054

Re: On commit refresh gives ORA-12054

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 28 Oct 2004 05:24:12 +1000
Message-Id: <417ff5cb$0$21974$afc38c87@news.optusnet.com.au>


Kamal wrote:

> Hi all.
>
> Can anyone explain me why this materialized view gives this error?
>
> create materialized view test
> refresh on commit
> enable query rewrite as
> select * from t;
>
> I know this mv is unuseful, but if it gives me this error on such a
> simple query you can imagine on a more complex one...
> Oracle 817 on windows.
>
> Thank you
>
> Kamal

I don't remember all error numbers. Perhaps you'd care to enlighten us as to what the error TEXT says.

HJR Received on Wed Oct 27 2004 - 14:24:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US