Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to solve the problem that ORA-01940 can not delete the current connected users in oracle, which has a certain reference value, and interested friends can refer to it. I hope you can learn a lot after reading this article.

When conducting test environment data import, you need to remember the drop user operation. When executing drop user, prompt: ORA-01940: cannot drop a user that is currently connected

SQL > drop user ecity; drop user ecity*ERROR at line 1:ORA-01940: cannot drop a user that is currently connected

The problem is obvious, there is a user connecting, drop is not allowed to drop the user.

Select username,sid,serial#,paddr from v$session where username='ECITY' USERNAME SID SERIAL# PADDR-- ECITY 634 7 00000000C028D198SQL > select PROGRAM from v$process where addr='00000000C028D198' PROGRAM-oracle@oradb01 (DW00) SQL > SQL > alter system kill session '634 System altered.SQL > SQL > select saddr,sid,serial#,paddr,username,status from v$session where username is not null;SQL > drop user ecity CASCADE;User dropped.SQL >

To solve the problem, remember to see what process it is, which machine is connected to it, whether it can KILL and so on before the KILL process. The test environment is fine, and the production is fine.

Thank you for reading this article carefully. I hope the article "how to solve the problem of ORA-01940 unable to delete current connected users in oracle" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.