删除已连接用户

1 删除表空

   drop tablespace  tbs including contents;

 

 

2删除一个连接的用户
SQL> select sid.serial# from v$session where username-^H;
select sid.serial# from v$session where username-
                                                 *
ERROR at line 1:
ORA-00911: invalid character

SQL> select sid,serial# from v$session where username='ECN';

       SID    SERIAL#
---------- ----------
 15  3279

SQL> alter system kill session '15,3279';

System altered.

SQL> drop user ECN cascade;

User dropped.

SQL>