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;
上一篇下一篇

猜你喜欢

热点阅读