通过OEM或者SQLPLUS 删除用户ORACLETEST没反应,强行结束后,再删除也不行.加 cascade也不行.其他用户也是一样.
环境:AIX5.2,ORACLE 9i
下面是相关检查步骤,但还是找不到原因,请专家帮忙解决为谢!
SQL> drop user oracletest;
drop user oracletest
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connectedSQL> select username,sid,serial# from v$session where username='oracletest';no rows selectedSQL> select username,sid,serial# from v$session where username='oracletest'
2 ;no rows selectedSQL> select username,sid,serial# from v$session where username='airmate2007';no rows selectedSQL> select username,sid,serial# from v$session where username='amt2007';no rows selectedSQL> drop user oracletest;
drop user oracletest
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
SQL> select job from dba_jobs where log_user='oracletest';no rows selectedSQL> select queue_table, qid from dba_queues where owner='oracletest';no rows selectedSQL> select capture_name, queue_name, from dba_capture where queue_owner='oracle
test';
select capture_name, queue_name, from dba_capture where queue_owner='oracletest'
*
ERROR at line 1:
ORA-00936: missing expression
SQL> select propagation_name from dba_propagation where source_queue_owner='orac
letes' or destination_queue_owner='^CSQL> select propagation_name from dba_propagation where source_queue_owner='orac
letest' or destination_queue_owner='oracletest';no rows selectedSQL> select apply_name from dba_apply where queue_owner=''oracletest';
ERROR:
ORA-01756: quoted string not properly terminated
SQL>
环境:AIX5.2,ORACLE 9i
下面是相关检查步骤,但还是找不到原因,请专家帮忙解决为谢!
SQL> drop user oracletest;
drop user oracletest
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connectedSQL> select username,sid,serial# from v$session where username='oracletest';no rows selectedSQL> select username,sid,serial# from v$session where username='oracletest'
2 ;no rows selectedSQL> select username,sid,serial# from v$session where username='airmate2007';no rows selectedSQL> select username,sid,serial# from v$session where username='amt2007';no rows selectedSQL> drop user oracletest;
drop user oracletest
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
SQL> select job from dba_jobs where log_user='oracletest';no rows selectedSQL> select queue_table, qid from dba_queues where owner='oracletest';no rows selectedSQL> select capture_name, queue_name, from dba_capture where queue_owner='oracle
test';
select capture_name, queue_name, from dba_capture where queue_owner='oracletest'
*
ERROR at line 1:
ORA-00936: missing expression
SQL> select propagation_name from dba_propagation where source_queue_owner='orac
letes' or destination_queue_owner='^CSQL> select propagation_name from dba_propagation where source_queue_owner='orac
letest' or destination_queue_owner='oracletest';no rows selectedSQL> select apply_name from dba_apply where queue_owner=''oracletest';
ERROR:
ORA-01756: quoted string not properly terminated
SQL>
解决方案 »
- LOG 文件怎么打开
- 求高手帮我解决下分表的存储过程(存储过程高手进)
- oracle 如何直接定位到指定的记录!!!急急!!
- 从Sql Server转入Oracle写的第一个存储过程,就遇上问题了,信心倍受打击,高人请指点下!!!谢谢了!
- 如何用oracle存储过程把Blob字段写成图片
- 我在改别人的程序,有个语句我看不懂,请指教!
- 求助:我的写法有错吗?ORA-00984,ORA-06512错误..?
- 不包含参数的存储过程应该如何建立?
- 游标溢出,各位帮帮我呀!!
- sql问题。
- Oracle.DataAccess.Client.OracleException ORA-06550: 第 1 行, 第 7 列: PLS-00103: 出现符号 "{"在需要下列之一时: 错误是什么原因?
- oracle 判断星期日 ???
在问问题的时候,自己先思考下
cannot drop a user that is currently connected
很明显的错误提示,那自己再去看下这个用户在那里还处于连接状态呢
--先用sys or system 登录
--drop user username cascade; --用户名要大写,如果不行的话就用下面的
--oracle 正在连接的用户不能删除,确实要删除的话
--第一步 用户名要大写
select sid,serial#,username from v$session where user='USERNAME';
--第二步
alter system kill session 'sid,serial#';
--第三步
drop user username cascade;