Re: Materialized view refresh fast without Primary key

  • From: "Chirag DBA" <chiragdba@xxxxxxxxx>
  • To: "Hemant K Chitale" <hkchital@xxxxxxxxxxxxxx>
  • Date: Mon, 23 Apr 2007 10:39:35 -0400

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

Other related posts: