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
/

Featured Post :

An "Awesome" List of Resources

Here's an "Awesome" List of Resources  https://github.com/sindresorhus/awesome . . .  

Preview Popular Posts