This video demonstrates how to solve the ORA-01940 cannot drop a user that is currently connected error. This error is raised when we try to drop a user that is connected to the database or having an active connection to the database.
We will demonstrate a solution in which we would kill the user that is connected to the oracle database by its serial# and PID.
This tutorial will guide viewers on how to kill an active session and then drop the user.
If you would like to look at more such videos please visit
/ kishanmashru
Visit our blog at
www.oracleplsqlblog.com