Re: Materialized view refresh fast without Primary key

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Sat, 21 Apr 2007 23:03:44 +0800
Message-Id: <200704211504.l3LF44MB003998@smtp41.singnet.com.sg>

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_at_gmail.com>afatkulin_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Apr 21 2007 - 10:03:44 CDT