3

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?

Improve this question
4
  • I've seen it also with a Materialized View with refresh on commit.
    – vercelli
    Commented Aug 22, 2016 at 8:05
  • can you confirm what you mean by a runtime exception?
    – Andrew Brennan
    Commented Aug 22, 2016 at 11:54
  • By that, I mean an error that prevents commit.
    – Mikayil Abdullayev
    Commented Aug 22, 2016 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
    Commented Aug 22, 2016 at 18:58

1 Answer 1

Reset to default
0

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 and acknowledge you have read our privacy policy.

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