Fast Refresh using two non-primary key tables

Hi,

I have a materialized view based on two tables with an outer join clause. Both the tables do not have a primary key so I had created materialized view log with row-id on each of them but still I am not able to bring out the fast refresh option for the materialized view. My question is can I have a fast refresh option for materialized view built from two tables without primary keys and having an outer join clause????. If possible please send me some sample scripts for quicker understanding.

Thanks and Regards,
Sudhakar

I believe that the fast refresh option relies on having a primary key.
Why don't you have a primary key on those tables?

I cannot have primary keys on the tables since those are proprietary tables of another application. Are they any workarounds?

Rgds,
Sudhakar

Quote:

---

Originally Posted by rksudhakar

I have a materialized view based on two tables with an outer join clause

---

"If the WHERE clause of the query contains outer joins, then unique constraints must exist on the join columns of the inner join table" (1)

RTFM ;)

(1) Metalink; Note:222843.1

Quote:

---

Originally Posted by rksudhakar

I cannot have primary keys on the tables since those are proprietary tables of another application. Are they any workarounds?

---

W/o PK or Unique Key means they are temporary tables. Am I right?

Quote:

---

Originally Posted by tamilselvan

W/o PK or Unique Key means they are temporary tables. Am I right?

---

Heh heh heh ... troll ;)

Quote:

---

Originally Posted by slimdave

Heh heh heh ... troll ;)

---

Hmm.. I am not surprised by your answer. May be I need to write the fundamental definition of normalization process.

The precursor definition in the normalization process is, all entities are uniquely identifable by a combination of attributes and / or relationships.