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

SELECT SID,SERIAL#,USERNAME,STATUS FROM V$SESSION WHERE SCHEMANAME=’apm’;

조회결과
——————————————–
SID SERIAL# USERNAME STATUS
— ——- ———- ——–
167  2416   APM        INACTIVE

—————————————————–

ALTER SYSTEM KILL SESSION ‘167,2416’ IMMEDIATE;

DROP USER test CASCADE;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s