Re: Materialized view refresh fails - m_row$$ column

The problem is with m_row$$ identifier as it is not thr in the base table but present in the mview log, so that the reason it is giving invalid identifier

Regards,
Arun

On Tue, Sep 4, 2018, 03:39 Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> You should trap the 904 error to find out what identifier is the problem.
>
>
> On 09/03/2018 01:35 PM, Arun Chugh wrote:
> >
> >
> > Now after somedays, it is giving below error, any idea why it is
> > behaving like this. Please suggest.
> >
> > Ora-12018 and ora -00904 m_row$$ invalid identifier
> >
> > Regards,
> > Arun
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l