Re: Materialized view refresh fast without Primary key
- From: "Chirag DBA" <chiragdba@xxxxxxxxx>
- To: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
- Date: Thu, 19 Apr 2007 22:31:17 -0400
Yes. It works.
didn notice as generally doing it through DB LINK on differenct DBs.
Thank you dude. :)
Chirag
On 4/19/07, Alexander Fatkulin <afatkulin@xxxxxxxxx> wrote:
You should also have grant select on mv log to that user.
grant select on mlog$_MV_T to ...
>
> Wondering how come I am not able to, or How can you simple create it ?
--
Alexander Fatkulin
--
Cheers,
------------------------
Chirag Majmundar
- References:
- Fwd: Materialized view refresh fast without Primary key
- From: Chirag DBA
- Re: Materialized view refresh fast without Primary key
- From: Alexander Fatkulin
- Re: Materialized view refresh fast without Primary key
- From: Chirag DBA
- Re: Materialized view refresh fast without Primary key
- From: Alexander Fatkulin
- Re: Materialized view refresh fast without Primary key
- From: Chirag DBA
- Re: Materialized view refresh fast without Primary key
- From: Alexander Fatkulin
Other related posts:
- » Re: Materialized view refresh fast without Primary key
- » Re: Materialized view refresh fast without Primary key
- » Re: Materialized view refresh fast without Primary key
- » Re: Materialized view refresh fast without Primary key
- » Re: Materialized view refresh fast without Primary key
- » Re: Materialized view refresh fast without Primary key
- » Re: Materialized view refresh fast without Primary key
- » Re: Materialized view refresh fast without Primary key
You should also have grant select on mv log to that user. grant select on mlog$_MV_T to ... > > Wondering how come I am not able to, or How can you simple create it ? -- Alexander Fatkulin
- Fwd: Materialized view refresh fast without Primary key
- From: Chirag DBA
- Re: Materialized view refresh fast without Primary key
- From: Alexander Fatkulin
- Re: Materialized view refresh fast without Primary key
- From: Chirag DBA
- Re: Materialized view refresh fast without Primary key
- From: Alexander Fatkulin
- Re: Materialized view refresh fast without Primary key
- From: Chirag DBA
- Re: Materialized view refresh fast without Primary key
- From: Alexander Fatkulin