Re: Materialized view refresh fast without Primary key
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: chiragdba@xxxxxxxxx, "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
- Date: Sat, 21 Apr 2007 23:03:44 +0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts: