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




Reply With Quote