Database Software

Hi everybody,

I configure bidirectional streams between two schemas SC1 and SC2 in diferents database, with one table tb1 in each schema.

I just created a trigger on tb1 in SC1 schema; before insert into tb1 (SC1) insert into another table of another schema.

when i insert into tb1 (SC1) the trigger works ok, but replication no works, and there is error in dba_apply_error:

ORA-04098: trigger TRIGGER_NAME is invalid and failed re-validation

how i can solve it?
Is neccesary create trigger on SC2?

I'm new in Oracle Streams and i have many doubt.

Thanks in advance.