| 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 ?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
