How to solve ORA-01940: cannot drop a user that is currently connected

Опубликовано: 16 Октябрь 2024
на канале: Kishan Mashru
6,938
31

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