oracle查看數(shù)據(jù)文件是否有數(shù)據(jù)？

查看那些庫的話必須用dba權(quán)限登錄。登陸后可以通過下面的方法來查看。一、查看有哪些庫，你的庫理解不準確，應(yīng)該準確來說是表空間，可以通過下面的命令來實現(xiàn)12345678910111213 SELECT Total.name "Tablespace Name",Free_space, (Total_space-Free_space) Used_space, total_spaceFROM(select tablespace_name, sum(bytes/1024/1024) Free_Spacefrom sys.dba_free_spacegroup by tablespace_name) Free,(select b.name, sum(bytes/1024/1024) TOTAL_SPACEfrom sys.v_$datafile a, sys.v_$tablespace Bwhere a.ts# = b.ts#group by b.name) TotalWHERE Free.Tablespace_name = Total.name二、查看有哪些表。1 select table_name from dba_tables where owner='A';