table space auto extent 조회

조회법

 

 

col tablespace_name for a20 col file_name for a35 SQL> select tablespace_name, file_name, autoextensible from dba_data_files; <결과 값> 맨끝 AUTOEX(AUTOEXTENSIBLE이 짤린것임) 부분이 YES면 AUTO EXTENT 이다. TABLESPACE_NAME     FILE_NAME                                                           AUTOEX --------------------   -----------------------------------                         ------ USERS                      C:\ORACLEXE\APP\ORACLE\ORADATA\XE\U     YES                                 SERS.DBF UNDOTBS1                C:\ORACLEXE\APP\ORACLE\ORADATA\XE\S      YES                                 YSAUX.DBF SYSAUX                    C:\ORACLEXE\APP\ORACLE\ORADATA\XE\U      YES                                 NDOTBS1.DBF SYSTEM                    C:\ORACLEXE\APP\ORACLE\ORADATA\XE\S      YES                                 YSTEM.DBF