oracle查看表空间信息

表空间，可以通过下面的命令来实现

SELECT Total.name "Tablespace Name",
Free_space, (total_space-Free_space) Used_space, total_space
FROM
(select tablespace_name, sum(bytes/1024/1024) Free_Space
from sys.dba_free_space
group by tablespace_name
) Free,
(select b.name, sum(bytes/1024/1024) TOTAL_SPACE
from sys.v_$datafile a, sys.v_$tablespace B
where a.ts# = b.ts#
group by b.name
) Total
WHERE Free.Tablespace_name = Total.name

如果只是查看表

select table_name from dba_tables where owner='A';

select * from user_tables --查询当前用户所拥有的表

select * from dba_tables --拥有DBA权限用户能查询所有的表

select * from all_tables --查询当前用户能访问的表