Oracle 12cで表領域が自動拡張かどうかを確認
環境
Oracle 12.2.0.1.0
SQL構文
SELECT
TABLESPACE_NAME
,FILE_NAME
,AUTOEXTENSIBLE
FROM
DBA_DATA_FILES;
SELECT
TABLESPACE_NAME
,FILE_NAME
,AUTOEXTENSIBLE
FROM
DBA_DATA_FILES;
SELECT TABLESPACE_NAME ,FILE_NAME ,AUTOEXTENSIBLE FROM DBA_DATA_FILES;
結果
TABLESPACE_NAME FILE_NAME AUTOEXTENSIBLE
SYSTEM F:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF YES
SYSAUX F:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF YES
TABLESPACE_NAME FILE_NAME AUTOEXTENSIBLE
SYSTEM F:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF YES
SYSAUX F:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF YES
TABLESPACE_NAME FILE_NAME AUTOEXTENSIBLE SYSTEM F:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF YES SYSAUX F:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF YES
説明
AUTOEXTENSIBLE列の値 YES->自動拡張 NO->自動拡張しない