Oracle查看表空间在磁盘上的路径
2016-01-28 本文已影响47人
ilaoke
https://docs.oracle.com/cd/B19306_01/server.102/b14231/tspaces.htm#i1007631
select * from DBA_TABLESPACES;
select * from USER_TABLESPACES;
SELECT FILE_NAME, BLOCKS, TABLESPACE_NAME FROM DBA_DATA_FILES order by TABLESPACE_NAME;
