tks prakashs43

check when the trigger got disabled .

select object_name, , last_ddl_time , timestamp from all_objects where object_type='TRIGGER' ;
....dooh, what a rookie mistake, i guess I should have checked that before I renabled the trigger

if u have applied any patch on the database just check if
system_enabled_trigger=FALSE is set or not ?
...no not the case

do u use materialised views for replication ??
>no