oralce扩展表空间

col TABLESPACE_NAME format a30
set pagesize 9999
col GB format 99999.999
select TABLESPACE_NAME,sum(bytes)/1024/1024/1024 GB from dba_data_files group by  TABLESPACE_NAME order by TABLESPACE_NAME;
!date
select TABLESPACE_NAME,sum(bytes)/1024/1024/1024 GB from dba_free_space group by  TABLESPACE_NAME order by TABLESPACE_NAME;
 
alter tablespace TBS_DATA_SIG_ETL_RPT add datafile '/opt/oracle/oradata/tbs_data_sig_etl_rpt/tbs_data_sig_etl_rpt_16g_02' size 16G autoextend off;

alter tablespace TBS_DATA_SIG_USER_RPT1 add datafile '/opt/oracle/oradata/tbs_data_sig_user_rpt1/tbs_data_sig_user_rpt1_02.dbf' size 2G autoextend off;
alter tablespace TBS_DATA_SIG_USER_RPT2 add datafile '/opt/oracle/oradata/tbs_data_sig_user_rpt1/tbs_data_sig_user_rpt2_02.dbf' size 2G autoextend off;
alter tablespace TBS_DATA_SIG_USER_RPT3 add datafile '/opt/oracle/oradata/tbs_data_sig_user_rpt1/tbs_data_sig_user_rpt3_02.dbf' size 2G autoextend off;
alter tablespace TBS_DATA_SIG_USER_RPT4 add datafile '/opt/oracle/oradata/tbs_data_sig_user_rpt1/tbs_data_sig_user_rpt4_02.dbf' size 2G autoextend off;
alter tablespace TBS_DATA_SIG_USER_RPT5 add datafile '/opt/oracle/oradata/tbs_data_sig_user_rpt1/tbs_data_sig_user_rpt5_02.dbf' size 2G autoextend off;
su - oracle
sqlplus / as sysdba
alter tablespace TBS_DATA_SIG_ETL_RPT add datafile '/opt/oracle/oradata/tbs_data_sig_etl_rpt/tbs_data_sig_etl_rpt_8g_03' size 8G autoextend off;