Monthly Archives: August 2014

ORA-01940: cannot drop a user that is currently connected solved

select sid, serial# from v$session where username = ‘AXF’; Alter user AXF account lock; alter system kill session ‘209,8029’; drop user AXF cascade; Advertisements

Posted in database, oracle | Tagged , , , | Leave a comment