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
/