Oracle 19cで表領域の自動拡張を確認する
環境
Oracle 19c(19.3.0.0.0)
書式
SELECT TABLESPACE_NAME, FILE_NAME, AUTOEXTENSIBLE FROM DBA_DATA_FILES ORDER BY 1
操作例
1.表示幅の設定
SQL> set linesize 1000 SQL> column TABLESPACE_NAME format a10 SQL> column FILE_NAME format a50 SQL> column AUTOEXTENSIBLE format a10
2.SQL構文を実行
SQL> SELECT TABLESPACE_NAME, FILE_NAME, AUTOEXTENSIBLE FROM DBA_DATA_FILES ORDER BY 1
3.実行結果
TABLESPACE FILE_NAME AUTOEXTENS ---------- -------------------------------------------------- ---------- SYSAUX C:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF YES SYSTEM C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF YES UNDOTBS1 C:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF YES USERS C:\ORACLE\ORADATA\ORCL\USERS01.DBF YES