查询所有schema
select distinct object_name TABLE_SCHEMA from all_objects where object_type='SCH';
查询指定用户下的schema
select distinct object_name TABLE_SCHEMA from all_objects where object_type='SCH' AND OWNER='SYSDBA';
查询表空间
select tablespace_name from dba_tablespaces;
查询所有表
select TABLE_NAME from dba_tables;
查询表空间
select tablespace_name from dba_tablespaces;