查看所有表空间信息:
select tablespace_name,status,allocation_type from dba_tablespaces;
查看每个用户的默认表空间:
select user_id,username,default_tablespace from dba_users;
查看所有表空间信息:
select tablespace_name,status,allocation_type from dba_tablespaces;
查看每个用户的默认表空间:
select user_id,username,default_tablespace from dba_users;