Re: Materialized view refresh fails - m_row$$ column
From: Tony <dedba_at_tpg.com.au>
Date: Tue, 04 Sep 2018 09:46:50 +1000
Message-ID: <5AFF1CB7-B85D-4096-AE15-3B1DA729666F_at_tpg.com.au>
Date: Tue, 04 Sep 2018 09:46:50 +1000
Message-ID: <5AFF1CB7-B85D-4096-AE15-3B1DA729666F_at_tpg.com.au>
Surely you are not attempting to build a materialised view on a materialised view log?
Cheers
On 4 September 2018 8:08:58 am AEST, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:
Tony
>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
-- Sent from my Android device with K-9 Mail. Please excuse my brevity. -- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 04 2018 - 01:46:50 CEST