set echo off
set line 120
set pages 1000
— DBA_TABLESPACES 表領域の状態
SELECT tablespace_name, initial_extent, next_extent, min_extents, max_extents
FROM dba_tablespaces
WHERE tablespace_name = ‘RBS’;
— OR tablespace_name = ‘TSTTBLP02’
— DBA_DATA_FILES データファイル（表領域）の状態
SELECT file_name, tablespace_name, bytes, blocks, status
FROM dba_data_files
WHERE tablespace_name = ‘TSTTBLP01’
OR tablespace_name = ‘TSTTBLP02’;
— DBA_FREE_SPACE
SELECT TABLESPACE_NAME,BYTES
FROM dba_free_space
WHERE TABLESPACE_NAME = ‘RBS’;
set echo on
