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