||Oracle Replication Tips by Burleson
To Other Schemas
‘create materialized view log on ‘|| table_name ||
‘tablespace users using primary key;’
SEE CODE DEPOT FOR FULL SCRIPT;
set pages 999 line 79 feedback on
Review the two scripts (Materialized View_logs_rowid.sql
and Materialized View_logs_pk.sql)
and remove any table that is not being dynamically replicated. The
scripts generated will look like the following, when executed in the
create materialized view log on DEPT tablespace users with primary
create materialized view log on EMP tablespace users with primary
create materialized view log on BONUS tablespace users with rowid;
create materialized view log on SALGRADE tablespace users with
Remove any table not being replicated and run the scripts to create
the materialized view logs.
A similar script can be used to create the Materialized Views
on the remote site.
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
Get a Personal Oracle
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.