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: Alexander Fatkulin <afatkulin_at_gmail.com>
Date: Fri, 20 Apr 2007 13:24:15 +1100
Message-ID: <49d668000704191924l7b06aacbs5dc2a845ab17d882@mail.gmail.com>


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
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 19 2007 - 21:24:15 CDT

Original text of this message

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