查看用户名-默认表空间-临时表空间select username, default_tablespace, temporary_tablespace from dba_users;
查看表空间信息select t.* from dba_tablespaces t where t.TABLESPACE_NAME ='USERS'
查看文件名(文件存储路径)-表空间-字节数
select file_name , tablespace_name , bytes from dba_data_files;