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.
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