Re: Materialized view refresh fails - m_row$$ column

Yes I am using source base table to create the mview. Not the mview log

Regards,
Arun

On Tue, Sep 4, 2018, 05:17 Tony <dedba_at_tpg.com.au> wrote:

> Surely you are not attempting to build a materialised view on a
> materialised view log?
>
> Cheers
> Tony
>
> On 4 September 2018 8:08:58 am AEST, 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
>>>
>>
> --
> Sent from my Android device with K-9 Mail. Please excuse my brevity.
>

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