select user_name from dba_users;
select tablespace_name from dba_tablaspaces;
select object_name from dba_objects where owner='USERNAME' and object_type='YOURTYPE'
select tablespace_name from dba_tablaspaces;
select object_name from dba_objects where owner='USERNAME' and object_type='YOURTYPE'
user_/all_/dba_tablespaces
user_/all_/dba_objects
dba具有相关权限才能查看