ORA-01940: cannot drop a user that is currently connected?
Sunday, March 1, 2015
SELECT SID, SERIAL#, MACHINE, USERNAME FROM V$SESSION WHERE USERNAME='TOBREMOVEDUSER' ; alter system kill session 'SID,SERIAL'; DROP USER TOBREMOVEDUSER CASCADE;
SELECT SID, SERIAL#, MACHINE, USERNAME FROM V$SESSION WHERE USERNAME='TOBREMOVEDUSER' ; alter system kill session 'SID,SERIAL'; DROP USER TOBREMOVEDUSER CASCADE;
No comments :
Post a Comment