Search My Oracle Blog

Custom Search

11 July, 2012

ON COMMIT Refresh without a Primary Key


Today's question : How can you build an ON COMMIT Refresh Materialized View for a table that has no Primary Key ?
.
.
.

1 comment:

Anonymous said...

I guess, you may use ROWID?

CREATE SNAPSHOT LOG ON source_table
TABLESPACE source_tablespace
WITH ROWID
/

Aggregated by orafaq.com

Aggregated by orafaq.com
This blog is being aggregated by orafaq.com

Top 50 Oracle SQL Blogs 2016

Top 50 Oracle SQL Blogs 2016
Top 50 Oracle SQL Blogs 2016