oracle+数据库扩充,oracle数据库表空间扩容方法

--增加Stage层表空间

altertablespace DW_STG_TBSadd datafile ‘/u01/app/oracle/oradata/crm001/DW_STG_TBS21.dbf‘ size 7167M autoextend on;altertablespace DW_STG_TBSadd datafile ‘/u01/app/oracle/oradata/crm001/DW_STG_TBS22.dbf‘ size 7167M autoextend on;altertablespace DW_STG_TBSadd datafile ‘/u01/app/oracle/oradata/crm001/DW_STG_TBS23.dbf‘ size 7167M autoextend on;altertablespace DW_STG_TBSadd datafile ‘/u01/app/oracle/oradata/crm001/DW_STG_TBS24.dbf‘ size 7167M autoextend on;altertablespace DW_STG_TBSadd datafile ‘/u01/app/oracle/oradata/crm001/DW_STG_TBS25.dbf‘ size 7167M autoextend on;altertablespace DW_STG_TBSadd datafile ‘/u01/app/oracle/oradata/crm001/DW_STG_TBS26.dbf‘ size 7167M autoextend on;altertablespace DW_STG_TBSadd datafile ‘/u01/app/oracle/oradata/crm001/DW_STG_TBS27.dbf‘ size 7167M autoextend on;altertablespace DW_STG_TBSadd datafile ‘/u01/app/oracle/oradata/crm001/DW_STG_TBS28.dbf‘ size 7167M autoextend on;altertablespace DW_STG_TBSadd datafile ‘/u01/app/oracle/oradata/crm001/DW_STG_TBS29.dbf‘ size 7167M autoextend on;altertablespace DW_STG_TBSadd datafile ‘/u01/app/oracle/oradata/crm001/DW_STG_TBS30.dbf‘ size 7167M autoextend on;altertablespace DW_STG_TBSadd datafile ‘/u01/app/oracle/oradata/crm001/DW_STG_TBS31.dbf‘ size 7167M autoextend on;altertablespace DW_STG_TBSadd datafile ‘/u01/app/oracle/oradata/crm001/DW_STG_TBS32.dbf‘ size 7167M autoextend on;altertablespace DW_STG_TBSadd datafile ‘/u01/app/oracle/oradata/crm001/DW_STG_TBS33.dbf‘ size 7167M autoextend on;altertablespace DW_STG_TBSadd datafile ‘/u01/app/oracle/oradata/crm001/DW_STG_TBS34.dbf‘ size 7167M autoextend on;altertablespace DW_STG_TBSadd datafile ‘/u01/app/oracle/oradata/crm001/DW_STG_TBS35.dbf‘ size 7167M autoextend on;altertablespace DW_STG_TBSadd datafile ‘/u01/app/oracle/oradata/crm001/DW_STG_TBS36.dbf‘ size 7167M autoextend on;altertablespace DW_STG_TBSadd datafile ‘/u01/app/oracle/oradata/crm001/DW_STG_TBS37.dbf‘ size 7167M autoextend on;altertablespace DW_STG_TBSadd datafile ‘/u01/app/oracle/oradata/crm001/DW_STG_TBS38.dbf‘ size 7167M autoextend on;altertablespace DW_STG_TBSadd datafile ‘/u01/app/oracle/oradata/crm001/DW_STG_TBS39.dbf‘ size 7167M autoextend on;altertablespace DW_STG_TBSadd datafile ‘/u01/app/oracle/oradata/crm001/DW_STG_TBS40.dbf‘ size 7167M autoextend on ;