SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-21780: Maximum number of object durations exceeded

783602Apr 21 2011 — edited Apr 26 2011

Hello,

I am running a batch process that is looping through a holding table (about 1.5 million rows) and for each record is bascially calling the same procedures/functions and loading data into various tables. This is a standard set of packages/procedures/functions that runs fine on other databases. This load blows up after processing 840,000 records but if i restart it from where it blew up it carries on fine. I have looked on various sites and they all mentione recursive calling of functions but surely it would blow up every time on the same offending record??

Any ideas?

The version i am running is Oracle Database 10g Release 10.2.0.1.0 - 64bit Production.

Cheers,

Dan.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 24 2011

Added on Apr 21 2011

7 comments

10,693 views