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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Materialized view refresh fast without Primary key

Re: Materialized view refresh fast without Primary key

From: Chirag DBA <chiragdba_at_gmail.com>
Date: Thu, 19 Apr 2007 22:31:17 -0400
Message-ID: <1a3629600704191931w15635979m172b9b7812d1e83f@mail.gmail.com>


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_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 19 2007 - 21:31:17 CDT

Original text of this message

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