ORA-01555 Snapshot too old error
The ORA-01555 is caused by Oracle read consistency mechanism. If you have a long running SQL that starts at 11:00 AM, Oracle ensures that all rows are as they appeared at 11:00 AM, even if the query runs until noon.
Latest posts by Nagulu Polagani (see all)
- Oracle E-Business Suite 12.2.7 Released - September 9, 2017
- PKI-02010: Invalid MAC for Wallet. Wallet verification failed - August 24, 2017
- ORA-1691: unable to extend lobsegment - August 7, 2017