Re: ORA-3113 During delete from with subquery

From: david wendelken <davewendelken_at_earthlink.net>
Date: Mon, 25 Apr 2005 10:00:04 -0700 (PDT)
Message-ID: <14157161.1114448404460.JavaMail.root@statler.psp.pas.earthlink.net>

I've gotten this error when I had large deletes going on, which had a lot of cascading deletes, and I was using the generated Designer Table API, whose triggers used up a lot of PL/SQL table memory.

So, if you've got something going on that would use up a lot of memory, you might get the same problem.

3113 appears to be a catch-all error, meaning that if they didn't bother to tell you specifically what went wrong, you get this error. Enjoy. :( I always cringe when I get it.

-
--

http://www.freelists.org/webpage/oracle-l Received on Mon Apr 25 2005 - 13:04:23 CDT