Tuesday, July 7, 2009

Fast Refresh Materialized View

connect payroll
create materialized view log on payroll.employee;

connect payroll_audit
create materialized view payroll_audit.employee_mview as select * from payroll.employee;