Thursday, March 21, 2013

ORA-01940: Cannot drop user that is currently connected



select sid,serial#,osuser,machine from v$session where username='IPMS';

SID                    SERIAL#                OSUSER            MACHINE                                                        
---------------------- ---------------------- ------------------------------
139                    3262                   PRABHAKAR                       -Laptop              





alter system kill session '139,3262';


alter system kill succeeded.                     


DROP USER ABC CASCADE;





DROP USER ABC succeeded.
             

No comments:

Post a Comment