tablespace 목록과 data file 목록 조회

tablespace 목록 조회

select tablespace_name
     ,block_size
     ,segment_space_management
     ,status
from dba_tablespaces;

data file 목록 조회

select file_name
     ,bytes
     ,blocks
     ,status
     ,autoextensible
     ,online_status
     ,tablespace_name
from dba_data_files;