Oracle : ORA Errors



Cause for ORA-01555 - Snapshot too Old

In our previous post, we discussed the basics of ORA 01555 - Snapshot too Old error. In this post, we will understand the common causes of this error and some reasons on why this error happens and what can be done to prevent this error. It is highly recommended to read the previous post before reading the reasons for this error, as this would help the reader to understand the error in much detail ....

ORA-01436:CONNECT BY loop in user data

So, what is the problem? I got an error ORA 01436: CONNECT BY LOOP in user data. Hmm..What did you do to get this error? Nothing. I was just running a hierarchical query in Oracle and somehow ended up with this error. First, I don’t really know what this error means to me and secondly, I don’t know how it came in my query. Do you have the Query and the scripts to create and insert data ....

ORA 01555–Snapshot too Old–Rollback Information Overwritten

In this post, we will attempt to illustrate in detail, one of the two main reasons for Snapshot too Old error. It is advised to read about delayed block cleanout, as we will be making use of this terminology in this post. Scenario 1 – Rollback Information is Overwritten and is no longer available For illustration purposes, we will assume that a session overwrites the rollback information it ....

No comments:

Post a Comment