本例中我的登录用户是TEST,tablespace是TESTSPACE
1)查询当前用户表空间
select default_tablespace from dba_users where username='TEST';
2)查询所有表空间
语句一:select * from dba_tablespaces;
语句二:select * from v$tablespace;
3)查询用户下所有表
语句一: select * from user_tables;
语句二: select * from dba_tables where owner='TEST';
4)查询表空间下的用户
select distinct s.owner from dba_segments s where s.tablespace_name ='TESTSPACE';