Re: Materialized view refresh fast without Primary key
- From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
- To: "Chirag DBA" <chiragdba@xxxxxxxxx>
- Date: Fri, 20 Apr 2007 12:40:19 +1100
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@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxx > 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
