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