Configuring Materialized View Logs at the Master Site

To enable fast refresh of a materialized view, configure a materialized view log for its master table at the master site. A fast refresh is more efficient than a complete refresh, because it updates only rows that have changed since the last refresh. See "About Materialized View Refresh" for more information.

To configure materialized view logs: 

1. In Oracle Enterprise Manager, log in to the master site as an administrative user, such as SYSTEM.

2. Go to the Database Home page.

3. Click Data Movement to open the Data Movement subpage.

4. Click Setup in the Advanced Replication section.

5. On the Advanced Replication: Setup page, expand Updateable Materialized View Replication.

6. Select Create Materialized View log on source database tables for fast refresh.

7. Click Continue to open the Create Materialized View Log page.

8. Enter the schema name and table name for the master table in the form schema.table in the Schema.Table field, or click the flashlight icon to find the table.

9. Click Populate Columns.

10. If you have a specific tablespace for the materialized view log you are creating, then enter the tablespace name in the Tablespace field. Otherwise, leave <Default> in the field.

11. Ensure that Primary Key is selected in Refresh Types.

12. Click OK to create the materialized view log.

13. Repeat Steps 5 through 12 for each master table.