Hemant's Oracle DBA Blog
I am an Oracle Database Specialist in Singapore. Please note that this site uses cookies.
29 September, 2019
Basic Replication -- 6 : COMPLETE and ATOMIC_REFRESH
›
Till 9i, if you did a COMPLETE Refresh of a Single Materialized View, Oracle would do a TRUNCATE followed by an INSERT. If you did a COMPL...
25 September, 2019
Basic Replication -- 5 : REFRESH_METHOD : FAST or FORCE ?
›
In the previous blog post , I had a remark "We'll explore the implications of "REFRESH FAST" and just "REFRESH...
17 September, 2019
Basic Replication -- 4 : Data Dictionary Queries
›
Now that we have two Materialized Views against a Source table, how can we identify the relationship via the data dictionary ? This is th...
‹
›
Home
View web version