ROLLBACK

How to Resolve ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

by Ed Chen
March 6, 2023March 7, 2023

ORA-00054 There're several cases that throw ORA-00054. Alter Table Move Tablespace We tried to move table to another tablespace. SQL> show user USER is "HR"… Read More »

SQL Statement Hang? Why?

by Ed Chen
February 6, 2023June 6, 2023

SQL Statement Hang Statements hanging or waiting always has a reason, lock release. Let's see some cases. UPDATE TABLE Hangs You may saw something is… Read More »

How Oracle Unlock Table

by Ed Chen
September 28, 2022April 27, 2023

In this post, we'd like to talked about 2 topics: Lock Table Unlock Table Lock Table Oracle provides LOCK TABLE statements to let users lock… Read More »

How to Resolve ORA-02080: database link is in use

by Ed Chen
January 3, 2018August 27, 2021

ORA-02080 ORA-02080 means that the open database link you want to close is in use, you have to close the open transaction in a distributed… Read More »

JavaScript is not enabled. Please enable it and reload the page.