COMMIT

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, 2023February 14, 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 »

SQLPlus Connect and Disconnect

by Ed Chen
December 16, 2022February 22, 2023

SQLPlus Connect To connect a database, we usually use sqlplus, a text-based connection tool provided by Oracle to facilitate clients to connect to a running… Read More »

How Oracle Unlock Table

by Ed Chen
September 28, 2022March 21, 2023

Lock Table Oracle provides LOCK TABLE statements to let users lock table as their needs. For example: SQL> conn hr/hr@orclpdb Connected. SQL> lock table employees… 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 »