Fwd: Materialized view refresh fast without Primary key

From: Chirag DBA <chiragdba_at_gmail.com>
Date: Thu, 19 Apr 2007 20:50:00 -0400
Message-ID: <1a3629600704191750x31384faev68626a7141a4fb01@mail.gmail.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Apr 19 2007 - 19:50:00 CDT