||Oracle Replication Tips by Burleson
To Other Schemas
‘create materialized view ‘|| table_name ||
‘using primary key refresh force next sysdate +1 as \
select * from ‘|| table_name ||’@navdb.world;’
SEE CODE DEPOT FOR FULL SCRIPT
Spool the results to a file so you can
edit them to remove tables you do not want to replicate, and then
run the script on the remote site. Do the same with tables that
have no primary key and must use ROWIDs.
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.