Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients


Free Oracle Tips


Free Oracle App Server Tips


Oracle support

Oracle training

Oracle tuning


Remote Oracle

Custom Oracle Training


  Oracle Replication Tips by Burleson

Oracle Materialized View Log tablespace

You should always designate the tablespace to create the Materialized View log.  If you do not specify a tablespace, the Materialized View log’s tablespace will default to the SYSTEM tablespace. 

Some changes to the base table can invalidate materialized views, particularly if the log is created using ROWID.  Like indexes, if the base table is rebuilt using the ALTER TABLE MOVE command, the relationship between row IDs and actual rows is changed, invalidating both indexes and materialized views based on that table.  In this case, all of the table’s indexes would have to be rebuilt, and a complete refresh on the materialized view would have to be executed.  Similarly, if the master site database ever requires recovery, it is recommended that all replicated materialized views be completely refreshed.

Each replicated base table can have only one materialized view log.  If the base table is replicated to multiple remote locations, all of the remote materialized views will refresh from the same Materialized View log, in addition to any local materialized views using the base table. 

Updates, inserts, and deletes on the base tables cause changes in the row information to be placed in the materialized view logs.  As each remote materialized view refreshes, it will pull the information from the logs it needs to update itself.  Once all remote sites have refreshed, the old data is removed from the materialized view log. 

This is an excerpt from Oracle Replication By Rampant TechPress (only $19.95).  You can click here to order a copy and get instant access to the code depot:

Get a Personal Oracle Replication Mentor

The author is now offering personal mentors for Oracle DBAs where you can have an Oracle expert right at your fingertips, anytime day or night. We work with hundreds of Oracle databases every year, so we know exactly how to quickly assist you with any Oracle replication question. 

You can get me personally, or any Oracle Certified replication DBA with more than 20 years of full-time IT experience. 




Oracle performance tuning book



Oracle performance tuning software

Oracle performance tuning software
Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel


email BC:

Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.