UnixPedia : HPUX / LINUX / SOLARIS: Oracle : How to check AUTOEXTENSIBLE is OFF/ON

Tuesday, March 25, 2014

Oracle : How to check AUTOEXTENSIBLE is OFF/ON

Auto Extension of the data files with in  the file system (/jjc/SCCDLP1/SCCDLP1), so data will not get added/increased further in this file system beyond the allocation.
SQL> select FILE_NAME,TABLESPACE_NAME,STATUS,AUTOEXTENSIBLE,ONLINE_STATUS from dba_data_files where file_name like '/jjc/SCCDLP1/SCCDLP1%';

FILE_NAME                                     TABLESPACE_NAME                STATUS    AUT ONLINE_
--------------------------------------------- ------------------------------ --------- --- -------
/jjc/SCCDLP1/SCCDLP1/s_ecmemp_01_d_02.dbf   S_ECMEMP_01_D                  AVAILABLE NO  ONLINE
/jjc/SCCDLP1/SCCDLP1/s_jjcomp2_01_x_01.dbf  S_JJCOMP2_01_X                 AVAILABLE NO  ONLINE
/jjc/SCCDLP1/SCCDLP1/s_jjcomp2_01_d_01.dbf  S_JJCOMP2_01_D                 AVAILABLE NO  ONLINE
/jjc/SCCDLP1/SCCDLP1/s_jjcompa_01_d_01.dbf  S_JJCOMPA_01_D                 AVAILABLE NO  ONLINE
/jjc/SCCDLP1/SCCDLP1/s_jjcomp_01_d_02.dbf   S_JJCOMP_01_D                  AVAILABLE NO  ONLINE
/jjc/SCCDLP1/SCCDLP1/s_mhdata_01.dbf        MHDATA                         AVAILABLE NO  ONLINE
/jjc/SCCDLP1/oradat03/s_share_01_x_01.dbf    S_SHARE_01_X                   AVAILABLE NO  ONLINE
/jjc/SCCDLP1/oradat03/s_jjcomp2_01_d_02.dbf  S_JJCOMP2_01_D                 AVAILABLE NO  ONLINE
/jjc/SCCDLP1/oradat03/s_jjcomp_01_x_01.dbf   S_JJCOMP_01_X                  AVAILABLE NO  ONLINE
/jjc/SCCDLP1/oradat03/s_jjcomp_01_d_01.dbf   S_JJCOMP_01_D                  AVAILABLE NO  ONLINE
/jjc/SCCDLP1/oradat03/s_ecmemp_01_d_01.dbf   S_ECMEMP_01_D                  AVAILABLE NO  ONLINE
/jjc/SCCDLP1/oradat03/s_jjcompa_01_d_03.dbf  S_JJCOMPA_01_D                 AVAILABLE NO  ONLINE
/jjc/SCCDLP1/oradat03/s_lawrpt_01_x_02.dbf   S_LAWRPT_01_X                  AVAILABLE NO  ONLINE

13 rows selected.

No comments:

Post a Comment