Home » Server Options » Replication » Replication - Procedures
Replication - Procedures [message #366555] Tue, 05 December 2000 13:51
chandra
Messages: 31
Registered: October 2000
Member
How can I make use of procedure/functions/package in replication proceudres ?
Like I created Snapshot master group :
begin
dbms_repcat.create_master_repobject(
gname => '"KNIGHT_DBA_MG"',
type => 'PROCEDURE',
oname => '"SP_WARRANTY_TIER_TO_PROD"',
sname => '"KNIGHT_DBA"',
use_existing_object => TRUE,
copy_rows => TRUE);
end;
/

begin
dbms_repcat.generate_replication_support(
sname => '"KNIGHT_DBA"',
oname => '"SP_WARRANTY_TIER_TO_PROD"',
type => 'PROCEDURE',
min_communication => TRUE);
end;
/

How to add these into snapshot group and how can I use these procedures in my snapshot site ?
Previous Topic: Multi Master issue in Oracle 8i for Linux
Next Topic: Synchronous to asynchronous
Goto Forum:
  


Current Time: Thu Mar 28 13:44:26 CDT 2024