 |
|
Oracle Replication Tips by Burleson |
Creating the Oracle
Trusted and Untrusted Model
user REPRECV
as a receiver for the master groups REP_GROUP2 and REP_GROUP3.
connect system/?????
create user repadmin identified by repadmin;
grant connect, resource to repadmin;
execute dbms_repcat_admin.grant_admin_any_schema(
’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.
execute dbms_repcat.create_master_repgroup(
gname=> ’REP_GROUP2’);
execute dbms_repcat.create_master_repgroup(
gname=> ’REP_GROUP3’);
-- Now register the receiver.
execute dbms_repcat_admin.register_user_repgroup(
username => ’reprecv’,
privilege_type => ’receiver’,
list_of_gnames => ‘REP_GROUP2, REP_GROUP3’);
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
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
depot:
http://www.rampant-books.com/book_2003_2_replication.htm
|
|
|
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. |
|
|
