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: Mon, 23 Apr 2007 10:39:35 -0400
Message-ID: <1a3629600704230739k78497994k37a2a95b4f4ed172@mail.gmail.com>


No,

I didn need to.

It was just grant on the Mlog table was required and with rowid with fast refresh words as Alexander replied.

Thanx

Chirag

On 4/21/07, Hemant K Chitale <hkchital_at_singnet.com.sg> wrote:
>
>
> Your error this time is actually an ORA-942. Did you drop the base
> table TEMP ?
>
> Anayway, Alexandar's suggestion would work as :
>
> SQL> create table temp (no number);
>
> Table created.
>
> SQL> create materialized view log on temp with rowid(no) including new
> values;
>
> Materialized view log created.
>
> SQL> create materialized view temp1 refresh fast on demand
> 2 with rowid -- specifying with rowid as suggested
> 3 as select * from temp;
>
> Materialized view created.
>
> SQL> create materialized view temp2 refresh fast on demand
> 2 as select * from temp;
> as select * from temp
> *
> ERROR at line 2:
> ORA-12014: table 'TEMP' does not contain a primary key constraint
>
>
> Hemant
>
>
> At 09:34 AM Friday, Chirag DBA wrote:
> >No Luck.
> >
> >ERROR at line 1:
> >ORA-12018: following error encountered during code generation for
> "MV2"."TEMP"
> >ORA-00942: table or view does not exist
> >
> >On 4/19/07, Alexander Fatkulin
> ><<mailto:afatkulin_at_gmail.com>afatkulin_at_gmail.com> wrote:
> >Try using this instead:
> >
> >create materialized view temp
> >refresh fast on demand
> >with rowid
> >as select * from mv1.temp ;
>
>
> Hemant K Chitale
> http://hemantoracledba.blogspot.com
>
>

-- 
Cheers,
------------------------
Chirag Majmundar

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 23 2007 - 09:39:35 CDT

Original text of this message

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