Aslam o Alikum,

I want to replicate triggers and Views from master site to snapshot site. I have created some triggers in master site and i want that when ever i change this trigger in master site this trigger should also be changes at snapshot site by Oracle Replication.

Lets say i have create a trigger my_trig in master site as

BEGIN
DBMS_REPCAT.CREATE_MASTER_REPOBJECT(
gname => '"TRIG_GRP"',
type => 'TRIGGER',
oname => '"MY_TRIG"',
sname => '"HLRMIS7"',
copy_rows => false,
use_existing_object => false,
ddl_text => 'create or replace TRIGGER HLRMIS7.MY_TRIG Before insert OR UPDATE ON HLRMIS7.MY_TABLE
REFERENCING NEW AS NEW OLD AS OLD
For Each Row
Begin
-- Some Code
Null;
EXCEPTION
WHEN OTHERS THEN
RAISE;
END;');
END;
/

and then in snapshot site i have executed following procedure

BEGIN
DBMS_REPCAT.CREATE_SNAPSHOT_REPOBJECT(
gname => '"TRIG_GRP"',
sname =>
'"HLRMIS7"',
oname => '"MY_TRIG"',
type => 'TRIGGER');
END;
/

after that i have made some change in the trigger at master site by following code

BEGIN
DBMS_REPCAT.ALTER_MASTER_REPOBJECT(
sname => '"HLRMIS7"',
oname =>
'"MY_TRIG"',
type => 'TRIGGER',
ddl_text => 'create or replace TRIGGER
HLRMIS7.MY_TRIG
Before insert OR UPDATE ON HLRMIS7.MY_TABLE
REFERENCING NEW AS NEW
OLD AS OLD
For Each Row
Begin
-- Some Code
Null;
-- Some new Code

EXCEPTION
WHEN OTHERS
THEN
RAISE;
END;');
END;
/

Now what can i do to replicate this change to snapshot site ???????????????

Take Care
Allah Hafiz