常用的一些SQL语句

列出所有表空间
select tablespace_name from dba_tablespaces;

列出表空间所有表
select table_name,tablespace_name from user_tables where tablespace_name = '表空间名';

查看所有用户
select * from dba_user;
select * from all_users;
select * from user_users;

 

Oracle里面三种标准的权限
Connect，
resource
dba

GRANT CONNECT, RESOURCE to username;
 
删除表空间

DROP TABLESPACE tablespacename INCLUDING CONTENTS CASCADE CONSTRAINTS

删除用户
DROP USER username CASCADE