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 21:34:55 -0400
Message-ID: <1a3629600704191834s7ce29aaeq3519b27ef0bf3dc9@mail.gmail.com>


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 <afatkulin_at_gmail.com> wrote:
>
> Try using this instead:
>
> create materialized view temp
> refresh fast on demand
> with rowid
> as select * from mv1.temp ;
>
> On 4/20/07, Chirag DBA <chiragdba_at_gmail.com> wrote:
> > Can I refresh materialized view FAST when a primary table doesnt have a
> > primary key ?
> >
> > As per oracle it should work with ROWID option while creating MV logs.
> >
> > 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.
> >
> > -- On secondary site (Same db)
> >
> > SQL> create materialized view temp refresh on demand as select * from
> > mv1.temp ;
> > create materialized view temp refresh on demand as select * from
> mv1.temp
> >
> > *
> > ERROR at line 1:
> > ORA-12014: table 'TEMP' does not contain a primary key constraint
> >
> >
> > SQL> create materialized view temp as select * from mv1.temp;
> > create materialized view temp as select * from mv1.temp
> > *
> > ERROR at line 1:
> > ORA-12014: table 'TEMP' does not contain a primary key constraint
> >
> >
> > Anyone can tell me what I am doing wrong ?
> >
> > --
> > Cheers,
> > ------------------------
> > Chirag Majmundar
> >
> > --
> > Cheers,
> > ------------------------
> > Chirag Majmundar
>
>
> --
> Alexander Fatkulin
>

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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 19 2007 - 20:34:55 CDT

Original text of this message

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