OWNER
--------------------------------------------------------------------------------
TABLE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
--------------------------------------------------------------------------------
STATUS
------------------------
ADAMHUAN
ADAMHUAN_TABLE
USERS
VALID
SQL> select * from adamhuan.adamhuan_table;
NAME
------------------------------------------------------------
大叔
萝莉
御姐
SQL>
SQL> drop user adamhuan;
drop user adamhuan
*
第 1 行出现错误:
ORA-01922: 必须指定 CASCADE 以删除 'ADAMHUAN'
SQL> create user angel identified by oracle account unlock;
用户已创建。
SQL> grant create session,resource to angel;
授权成功。
SQL> drop user angel;
用户已删除。
SQL>