Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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.
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.
