1 以sysdba身份登录
>sqlplus /nolog;
>conn sys as sysdba;
>输入密码
2 查看要删除用户的连接情况
>select username,sid,serial# from v$session;
3 关闭该用户
>alter system kill session '99,65';
4 删除该用户
>drop user standdb_test;
1 以sysdba身份登录
>sqlplus /nolog;
>conn sys as sysdba;
>输入密码
2 查看要删除用户的连接情况
>select username,sid,serial# from v$session;
3 关闭该用户
>alter system kill session '99,65';
4 删除该用户
>drop user standdb_test;