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@xxxxxxxxxxxxxx> 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@xxxxxxxxx>afatkulin@xxxxxxxxx> 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