||Oracle Replication Tips by Burleson
Creating the Oracle
Trusted and Untrusted Model
as a receiver for the master groups REP_GROUP2 and REP_GROUP3.
create user repadmin identified by repadmin;
grant connect, resource to repadmin;
grant comment any table to repadmin;
grant lock any table to repadmin;
SEE CODE DEPOT FOR FULL SCRIPT
create user reprecv identified by reprecv;
grant connect, resource to reprecv;
-- First create the groups.
-- Now register the receiver.
Finally, we need to discuss the user who owns the data being
replicated. In this example, we are going to replicate the PUBS
schema from the NAVDB.WORLD
username => ’reprecv’,
privilege_type => ’receiver’,
list_of_gnames => ‘REP_GROUP2, REP_GROUP3’);
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
||Need an Oracle Health Check?
Does your boss blame you for an Oracle performance problem?
Need to prove that your database is properly optimized?
BC Oracle performance guru's can quickly verify every aspect of your
Oracle database and provide a complete certification that your database
is fully optimized.