drop user WEBER cascade constraint * ERROR 位于第 1 行: ORA-00933: SQL 命令未正确结束
用dba studio 中的安全性,移处用户即可 我试过没有任何问题
你关闭所有的ORACLE的工具,只留SQLPLUS 用system登陆
关闭了所有连接啊connect system/manager@shopdb; drop user WEBER cascade; drop user WEBER cascade * ERROR 位于第 1 行: ORA-01940: 无法删除当前已连接的用户
1.差不多是这个意思。 2.举例说明:先创建用户a/a,kill会话—— SQL> create user a identified by a;User createdSQL> grant create session to a;Grant succeededSQL> conn a/a; Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0 Connected as aSQL> conn sys as sysdba; Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0 Connected as SYSSQL> select sid,serial#,username,status from v$session; SID SERIAL# USERNAME STATUS ---------- ---------- ------------------------------ -------- 1 1 ACTIVE 2 1 ACTIVE 3 1 ACTIVE 4 1 ACTIVE 5 1 ACTIVE 6 1 ACTIVE 7 1 ACTIVE 8 1 ACTIVE 9 30 A INACTIVE --将要kill 的session对(会话)就是他 12 84 SYS ACTIVE 13 14 SYS INACTIVE11 rows selected11 rows selectedSQL> alter system kill session '9,30';System alteredSQL> select sid,serial#,username,status from v$session SID SERIAL# USERNAME STATUS ---------- ---------- ------------------------------ -------- 1 1 ACTIVE 2 1 ACTIVE 3 1 ACTIVE 4 1 ACTIVE 5 1 ACTIVE 6 1 ACTIVE 7 1 ACTIVE 8 1 ACTIVE 9 32 A KILLED --已kill会话 12 84 SYS ACTIVE 13 14 SYS INACTIVE11 rows selectedSQL>drop user a cascade;3.cascade constraint何意?:改为drop user a cascade就行了。
实在不行, kill一次该用户会话,再执行drop一次。
另外你说的想建一个空用户(即该用户下什么也没有),好像
是不可能的,因为一个用户对应一个模式,即然是模式,
也就有自己的一些特定对象,比如像系统表一类的。
2。如何kill这个用户的会话
3。cascade constraint何意?
*
ERROR 位于第 1 行:
ORA-00933: SQL 命令未正确结束
我试过没有任何问题
用system登陆
drop user WEBER cascade;
drop user WEBER cascade
*
ERROR 位于第 1 行:
ORA-01940: 无法删除当前已连接的用户
2.举例说明:先创建用户a/a,kill会话——
SQL> create user a identified by a;User createdSQL> grant create session to a;Grant succeededSQL> conn a/a;
Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0
Connected as aSQL> conn sys as sysdba;
Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0
Connected as SYSSQL> select sid,serial#,username,status from v$session; SID SERIAL# USERNAME STATUS
---------- ---------- ------------------------------ --------
1 1 ACTIVE
2 1 ACTIVE
3 1 ACTIVE
4 1 ACTIVE
5 1 ACTIVE
6 1 ACTIVE
7 1 ACTIVE
8 1 ACTIVE
9 30 A INACTIVE --将要kill
的session对(会话)就是他
12 84 SYS ACTIVE
13 14 SYS INACTIVE11 rows selected11 rows selectedSQL> alter system kill session '9,30';System alteredSQL> select sid,serial#,username,status from v$session SID SERIAL# USERNAME STATUS
---------- ---------- ------------------------------ --------
1 1 ACTIVE
2 1 ACTIVE
3 1 ACTIVE
4 1 ACTIVE
5 1 ACTIVE
6 1 ACTIVE
7 1 ACTIVE
8 1 ACTIVE
9 32 A KILLED --已kill会话
12 84 SYS ACTIVE
13 14 SYS INACTIVE11 rows selectedSQL>drop user a cascade;3.cascade constraint何意?:改为drop user a cascade就行了。
---------- ----------
1 1
2 1
3 1
4 1
5 1
6 1
7 6209
8 6209
9 6209
10 6209
13 7 SID SERIAL#
---------- ----------
18 7823sql>alter system kill session '10,6209';
alter system kill session 'sid,serial#'