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 12:40:19 +1100
Message-ID: <49d668000704191840x63be2325n76ff3b88e895bdfc@mail.gmail.com>


Well, now it's saying what there is now such table?

It works.

SQL> create table t (n number);

Table created.

SQL> create materialized view log on t with rowid (n) including new values;

Materialized view log created.

SQL> create materialized view mv_t
  2 refresh fast on demand
  3 with rowid as
  4 select * from t;

Materialized view created.

On 4/20/07, Chirag DBA <chiragdba_at_gmail.com> 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 <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

-- 
Alexander Fatkulin
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 19 2007 - 20:40:19 CDT

Original text of this message

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