1

I am getting this error when records are streamed over to another database

Oracle DB version:11.2.0.3.0

Transaction Flow: 
DML on Schema1@DB1 Streamed to Schema2@DB2 then trigger on this table will insert into
Schema3@DB2 then trigger on this table will insert into table in Schema4@DB2

ORA-21780 error happening at the last stage.

Please advise.

1

Somehow you are trying to keep too many PL/SQL objects (I mean "TYPE AS OBJECT" objects). There is an internal limitation of around 64k of these per session. This is on the client side (not on server side), so this is a programming error, not related to database administration.

Not if that matters, but if you are simply curious why this message speaks about "durations" see this doc.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.