1、以sysdba身份登录,查询所有用户
Select * From dba_users;
2、联级删除用户
Drop user HOS_ADMIN cascade;
3、查询所有表空间
Select * From dba_data_files;
4、删除表空间
Drop tablespace HOSPITAL_DATA including contents and datafiles cascade constraint;
1、以sysdba身份登录,查询所有用户
Select * From dba_users;
2、联级删除用户
Drop user HOS_ADMIN cascade;
3、查询所有表空间
Select * From dba_data_files;
4、删除表空间
Drop tablespace HOSPITAL_DATA including contents and datafiles cascade constraint;