I've been asked this question but neither I seem to be able to answer it on my own, nor can I find anything related on the web. So what are the cases that might cause a runtime exception when committing a transaction in Oracle?The only thing that I can think of is the low disk space. Are there any other?

  • I've seen it also with a Materialized View with refresh on commit. – vercelli Aug 22 '16 at 8:05
  • can you confirm what you mean by a runtime exception? – Andrew Brennan Aug 22 '16 at 11:54
  • By that, I mean an error that prevents commit. – Mikayil Abdullayev Aug 22 '16 at 12:19
  • or it could me one of the thousands of ORA-600, ORA-700 or ORA-7445 or ORA-4031 etc etc. it can be anything. Real question is why would someone want to know? because no matter what you account for, there could be something else that could go wrong. – Raj Aug 22 '16 at 18:58

I posted the same question to Oracle community and the answer was deferred constraints.

|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.